This year, Cairo Company sold 35,000 units its only product for $16 per unit. Manufacturing and selling the product required $120,000 of fixed manufacturing costs and $180,000 of fixed selling and administrative costs. Its per unit variable costs were as follows:
Next year, the company will use new material that is easier to work. The new material will reduce material costs by 60% and direct labour costs by 40% and will not affect quality or marketability. Management is considering an increase in the unit sales price to reduce the number of units sold because the factory’s output is nearing its annual capacity of 40,000 units. Two plans are being considered. Under Plan 1, the company will keep the price at the current level and sell the same volume as last year. Under Plan 2, the company will increase price by 25%. This price will decrease unit sales volume by 10%. Under both plans, total fixed costs and the variable costs per unit for overhead and for selling and administrative costs will remain the same.
Required:
1. Using Excel, prepare a fully labelled breakeven chart for both plans (2 charts). Charts should display all major and minor gridlines.
2. Using Excel, prepare a forecasted contribution statement for the current situation and both plans.
3. Advise the company, based on your results for requirements 1 and 2.
4. Why is spreadsheet analysis an important tool for management accountants?
NB. You will be assessed based on your use of the formulas.
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
apter 22 Questions 6-7 (of 8) The following information applies to the questions displayed below.] This year Cairo Company sold 30,000 units of its only product for $19.00 per unit. Manufacturing and selling the product required $115,000 of fixed manufacturing costs and $175,000 of fixed selling and administrative costs. Its per unit variable costs follow Material Direct labor (paid on the basis of completed units) Variable overhead costs Variable selling and administrative costs 3.50 2.50 0.35 0.15 Next year the...
[The following information applies to the questions displayed below.] This year Burchard Company sold 33,000 units of its only product for $18.40 per unit. Manufacturing and selling the product required $118,000 of fixed manufacturing costs and $178,000 of fixed selling and administrative costs. Its per unit variable costs follow. Material $ 3.80 Direct labor (paid on the basis of completed units) 2.80 Variable overhead costs 0.38 Variable selling and administrative costs 0.18 Next year the company will use new material,...
Problem 18-6A Analysis of price, cost, and volume changes for contribution margin and net income P2 @ A1 This year Burchard Company sold 40,000 units of its only product for $25 per unit. Manufacturing and selling the product required $200,000 of fixed manufacturing costs and $325,000 of fixed selling and administrative costs. Its per unit variable costs follow. Material Direct labor (paid on the basis of completed units) Variable overhead costs Variable selling and administrative costs $8.00 5.00 1.00 Next...
This year Burchard Company sold 27,000 units of its only product for $19.60 per unit. Manufacturing and selling the product required $112,000 of fixed manufacturing costs and $172,000 of fixed selling and administrative costs. Its per unit variable costs follow. Material $ 3.20 Direct labor (paid on the basis of completed units) 2.20 Variable overhead costs 0.32 Variable selling and administrative costs 0.12 Next year the company will use new material, which will reduce material costs by 60% and direct...
Required: 1. Compute the break-even point in dollar sales for both (a) plan 1 and (b) plan 2. (Round "per unit answers" and "CM ratio percentage answer to 2 decimal places.) This year Burchard Company sold 35,000 units of its only product for $16.00 per unit. Manufacturing and selling the product required $120,000 of fixed manufacturing costs and $180,000 of fixed selling and administrative costs. Its per unit variable costs follow Material Direct labor (paid on the basis of completed...
This year Bertrand Company sold 40,000 units of its only product for $25 per unit. Manufacturing and selling the product required $200,000 of fixed manufacturing costs and $325,000 of fixed selling and administrative costs. Its per unit variable costs follow. tion $8.00 5.00 Material Direct labor (pald on the basis of completed units) Variable overhead costs, Variable selling and administrative costs 1.00 10.50 Next year the company will use new material, which will reduce material costs by 50% and direct...
and tribution This year Bertrand Company sold 40,000 units of its only product for $25 per unit Manufacturing and selling the product required $200,000 of fixed manufacturing costs and $325.000 of fixed selling and administrative costs, Tes per unit variable costs follow. $0.00 Material Direct labor (paid on the basis of completed units). Variable overhead costs Variable selling and administrative, costs Next year the company will use new material, which will reduce material costs by 50% and direct labor costs...
Required information [The following information applies to the questions displayed below.] This year Burchard Company sold 45,000 units of its only product for $18.00 per unit. Manufacturing and selling the product required $130,000 of fixed manufacturing costs and $190,000 of fixed selling and administrative costs. Its per unit variable costs follow. Material $ 5.00 Direct labor (paid on the basis of completed units) 4.00 Variable overhead costs 0.50 Variable selling and administrative costs 0.30 Next year the company will use...
Required information (The following information applies to the questions displayed below) This year Burchard Company sold 45,000 units of its only product for $18.00 per unit. Manufacturing and selling the product required $130,000 of fixed manufacturing costs and $190,000 of fixed selling and administrative costs. Its per unit variable costs follow. Material Direct labor (paid on the basis of completed units) Variable overhead costs Variable selling and administrative costs $ 5.00 4.00 8.50 Next year the company will use new...
DC Quiz Saved Required information [The following information applies to the questions displayed below.] This year Burchard Company sold 32,000 units of its only product for $18.60 per unit. Manufacturing and selling the product required $117,000 of fixed manufacturing costs and $177,000 of fixed selling and administrative costs. Its per unit variable costs follow. Material Direct labor (paid on the basis of completed units) Variable overhead costs Variable selling and administrative costs $ 3.70 2.70 0.37 0.17 Next year the...