Susan wants to make some changes to the worksheet to explore the impact that changing input values has on the calculated values in the worksheet. She can use .

Ida sidha karya company is a family-owned company located on the island of bali in indonesia. the company produces a handcrafted balinese musical instrument called a gamelan that is similar to a xylophone. the gamelans are sold for $860. selected data for the company’s operations last year follow: units in beginning inventory 0 units produced 320 units sold 285 units in ending inventory 35 variable costs per unit: direct materials $ 135 direct labor $ 355 variable manufacturing overhead $ 30 variable selling and administrative $ 15 fixed costs: fixed manufacturing overhead $ 64,000 fixed selling and administrative $ 27,000 the absorption costing income statement prepared by the company’s accountant for last year appears below: sales $ 245,100 cost of goods sold 205,200 gross margin 39,900 selling and administrative expense 31,275 net operating income $ 8,625 required: 1. under absorption costing, how much fixed manufacturing overhead cost is included in the company's inventory at the end of last year? 2. prepare an income statement for last year using variable costing. what is the amount of the difference in net operating income between the two costing methods?

Suppose a firm faces a fixed price of output, 푝푝= 1200. the firm hires workers from a union at a daily wage, 푤푤, to produce output according to the production function 푞푞= 2퐸퐸12. there are 225 workers in the union. any union worker who does not work for this firm is guaranteed to find nonunion employment at a wage of $96 per day. a.what is the firm’s labor demand function? b.if the firm is allowed to choose 푤푤, but then the union decides how many workers to provide (up to 225) at that wage, what wage will the firm set? how many workers will the union provide? what is the firm’s output and profit? what is the total income of the 225 union workers? c.now suppose that the union sets the wage, but the firm decides how many workers to hire at that wage (up to 225). what wage will the union set to maximize the total income of all 225 workers? how many workers will the firm hire? what is the firm’s output and profit? what is the total income of the 225 union workers? [hint: to maximize total income of union, take the first order condition with respect to w and set equal to 0.]

Biochemical corp. requires $600,000 in financing over the next three years. the firm can borrow the funds for three years at 10.80 percent interest per year. the ceo decides to do a forecast and predicts that if she utilizes short-term financing instead, she will pay 7.50 percent interest in the first year, 12.15 percent interest in the second year, and 8.25 percent interest in the third year. assume interest is paid in full at the end of each year. a)determine the total interest cost under each plan. a) long term fixed rate: b) short term fixed rate: b) which plan is less costly? a) long term fixed rate plan b) short term variable rate plan