Millie is looking at the sales forecast for the sales of classic waffles. She has given you some costs and revenue information to use when drawing a break-even chart. FORECASTS ... Variable costs Total fixed costs per month Sales price of the Classic Waffle $0.50 $800 $2.20 Millie Forecasts that up to 1800 people a month will buy a classic waffle at $2.20. Plot the following to draw a break-even chart for the classic waffles. Remember to label it fully (Costs, Revenue, Break-Even). You may find it helpful to complete the Activity Table before you start the chart. Finally shade the area wherein the profit is positive. Number of Waffles 1000 1800 Sales Revenue Variable Costs Fixed Costs Total Costs Break-even Quantity

Millie is looking at the sales forecast for the sales of classic waffles. She has given you some costs and revenue information to use when drawing a break-even chart. FORECASTS ... Variable costs Total fixed costs per month Sales price of the Classic Waffle $0.50 $800 $2.20 Millie Forecasts that up to 1800 people a month will buy a classic waffle at $2.20. Plot the following to draw a break-even chart for the classic waffles. Remember to label it fully (Costs, Revenue, Break-Even). You may find it helpful to complete the Activity Table before you start the chart. Finally shade the area wherein the profit is positive. Number of Waffles 1000 1800 Sales Revenue Variable Costs Fixed Costs Total Costs Break-even Quantity

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 18M

See similar textbooks

Similar questions

Maple Enterprises sells a single product with a selling price of $75 and variable costs per unit of $30. The companys monthly fixed expenses are $22,500. What is the companys break-even point in units? What is the companys break-even point in dollars? Construct a contribution margin income statement for the month of September when they will sell 900 units. How many units will Maple need to sell in order to reach a target profit of $45,000? What dollar sales will Maple need in order to reach a target profit of $45,000? Construct a contribution margin income statement for Maple that reflects $150,000 in sales volume.
Jansen Crafters has the capacity to produce 50,000 oak shelves per year and is currently selling 44,000 shelves for $32 each. Cutrate Furniture approached Jansen about buying 1,200 shelves for bookcases it is building and is willing to pay $26 for each shelf. No packaging will be required for the bulk order. Jansen usually packages shelves for Home Depot at a price of $1.50 per shell. The $1.50 per-shelf cost is included in the unit variable cost of $27, with annual fixed costs of $320.000. However, the $130 packaging cost will not apply in this case. The fixed costs will be unaffected by the special order and the company has the capacity to accept the order. Based on this information, what would be the profit if Jansen accepts the special order? A. Profits will decrease by $1,200. B. Profits will increase by $31,200. C. Profits will increase by $600. D. Profits will increase by $7,200.
Kerr Manufacturing sells a single product with a selling price of $600 with variable costs per unit of $360. The companys monthly fixed expenses are $72,000. What is the companys break-even point in units? What is the companys break-even point in dollars? Prepare a contribution margin income statement for the month of January when they will sell 500 units. How many units will Kerr need to sell in order to realize a target profit of $120,000? What dollar sales will Kerr need to generate in order to realize a target profit of $120,000? Construct a contribution margin income statement for the month of June that reflects $600,000 in sales revenue for Kerr Manufacturing.
Basu Company produces two types of sleds for playing in the snow: basic sled and aerosled. The projected income for the coming year, segmented by product line, follows: The selling prices are 30 for the basic sled and 60 for the aerosled. (Round break-even packages and break-even units to the nearest whole unit.) Required: 1. Compute the number of units of each product that must be sold for Basu to break even. 2. Assume that the marketing manager changes the sales mix of the two products so that the ratio is five basic sleds to three aerosleds. Repeat Requirement 1. 3. CONCEPTUAL CONNECTION Refer to the original data. Suppose that Basu can increase the sales of aerosleds with increased advertising. The extra advertising would cost an additional 195,000, and some of the potential purchasers of basic sleds would switch to aerosleds. In total, sales of aerosleds would increase by 12,000 units, and sales of basic sleds would decrease by 5,000 units. Would Basu be better off with this strategy?
Marlin Motors sells a single product with a selling price of $400 with variable costs per unit of $160. The companys monthly fixed expenses are $36,000. What is the companys break-even point in units? What is the companys break-even point in dollars? Prepare a contribution margin income statement for the month of November when they will sell 130 units. How many units will Marlin need to sell in order to realize a target profit of $48,000? What dollar sales will Marlin need to generate in order to realize a target profit of $48.000? Construct a contribution margin income statement for the month of February that reflects $200,000 in sales revenue for Marlin Motors.
Cadre, Inc., sells a single product with a selling price of $120 and variable costs per unit of $90. The companys monthly fixed expenses are $180,000. What is the companys break-even point in units? What is the companys break-even point in dollars? Prepare a contribution margin income statement for the month of October when they will sell 10,000 units. How many units will Cadre need to sell in order to realize a target profit of $300,000? What dollar sales will Cadre need to generate in order to realize a target profit of $300,000? Construct a contribution margin income statement for the month of August that reflects $2,400,000 in sales revenue for Cadre, Inc.
Schylar Pharmaceuticals, Inc., plans to sell 130,000 units of antibiotic at an average price of 22 each in the coming year. Total variable costs equal 1,086,800. Total fixed costs equal 8,000,000. (Round all ratios to four significant digits, and round all dollar amounts to the nearest dollar.) Required: 1. What is the contribution margin per unit? What is the contribution margin ratio? 2. Calculate the sales revenue needed to break even. 3. Calculate the sales revenue needed to achieve a target profit of 245,000. 4. What if the average price per unit increased to 23.50? Recalculate: a. Contribution margin per unit b. Contribution margin ratio (rounded to four decimal places) c. Sales revenue needed to break even d. Sales revenue needed to achieve a target profit of 245,000
Country Diner currently makes cookies for its boxed lunches. It uses 40,000 cookies annually in the production of the boxed lunches. The costs to make the cookies are: A potential supplier has offered to sell Country Diner the cookies for $0.85 each. If the cookies are purchased, 10% of the fixed overhead could be avoided. If Jason accepts the offer, what will the effect on profit be?
Variety Artisans has a bottleneck in their production that occurs within the engraving department. Arjun Naipul, the COO, is considering hiring an extra worker, whose salary will be $45,000 per year, to solve the problem. With this extra worker, the company could produce and sell 3,500 more units per year. Currently, the selling price per unit is $18 and the cost per unit is $5.85. Using the information provided, calculate the annual financial impact of hiring the extra worker.
Shelby Industries has a capacity to produce 45.000 oak shelves per year and is currently selling 40,000 shelves for $32 each. Martin Hardwoods has approached Shelby about buying 1,200 shelves for a new project and is willing to pay $26 each. The shelves can be packaged in bulk; this saves Shelby $1.50 per shelf compared to the normal packaging cost. Shelves have a unit variable cost of $27 with fixed costs of $350,000. Because the shelves dont require packaging, the unit variable costs for the special order will drop from $27 per shelf to $25.50 per shelf. Shelby has enough idle capacity to accept the contract. What is the minimum price per shelf that Shelby should accept for this special order?
Hammond Company runs a driving range and golf shop. The budgeted income statement for the coming year is as follows. Required: 1. What is Hammonds variable cost ratio? Its contribution margin ratio? 2. Suppose Hammonds actual revenues are 200,000 greater than budgeted. By how much will before-tax profits increase? Give the answer without preparing a new income statement. 3. How much sales revenue must Hammond earn in order to break even? What is the expected margin of safety? (Round your answers to the nearest dollar.) 4. How much sales revenue must Hammond generate to earn a before-tax profit of 130,000? An after-tax profit of 90,000? (Round your answers to the nearest dollar.) Prepare a contribution margin income statement to verify the accuracy of your last answer.
Reubens Deli currently makes rolls for deli sandwiches it produces. It uses 30,000 rolls annually in the production of deli sandwiches. The costs to make the rolls are: A potential supplier has offered to sell Reuben the rolls for $0.90 each. If the rolls are purchased, 30% of the fixed overhead could be avoided, If Reuben accepts the offer, what will the effect on profit be?