Use the table below to answer questions about Christina's Christmas Wreaths. Christina operates in a perfectly competitive market for wreaths. Christina's Costs and Revenue Quantity Average Variable Average Total (wreaths) Marginal Cost (dollars) Marginal Revenue (dollars) Cost (dollars) Cost (dollars) 5 $20.00 $25.00 $20.00 $64.00 6 18.00 22.00 22.00 64.00 7 24.00 28.00 64.00 64.00 8 29.00 32.00 60.00 64.00 9 36.00 39.00 95.00 64.00 10 49.00 52.00 169.00 64.00 Instructions: In part a, enter your answer as a whole number. In parts b and c, round your answers to two decimal places. a. What is the profit-maximizing level of output for Christina's Christmas Wreaths?

Use the table below to answer questions about Christina's Christmas Wreaths. Christina operates in a perfectly competitive market for wreaths. Christina's Costs and Revenue Quantity Average Variable Average Total (wreaths) Marginal Cost (dollars) Marginal Revenue (dollars) Cost (dollars) Cost (dollars) 5 $20.00 $25.00 $20.00 $64.00 6 18.00 22.00 22.00 64.00 7 24.00 28.00 64.00 64.00 8 29.00 32.00 60.00 64.00 9 36.00 39.00 95.00 64.00 10 49.00 52.00 169.00 64.00 Instructions: In part a, enter your answer as a whole number. In parts b and c, round your answers to two decimal places. a. What is the profit-maximizing level of output for Christina's Christmas Wreaths?

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 20M

See similar textbooks

Similar questions

Many different businesses employ markup on cost to arrive at a price. For each of the following situations, explain what the markup covers and why it is the amount that it is. a. Department stores have a markup of 100 percent of purchase cost. b. Jewelry stores charge anywhere from 100 percent to 300 percent of the cost of the jewelry. (The 300 percent markup is referred to as keystone.) c. Johnson Construction Company charges 12 percent on direct materials, direct labor, and subcontracting costs. d. Hamilton Auto Repair charges customers for direct materials and direct labor. Customers are charged 45 per direct labor hour worked on their job; however, the employees actually cost Hamilton 15 per hour.
A small company manufactures a certain item and sells it online. The company has a business model where the cost, C in dollars, to make x items is given by the equation C = 20/3 x + 50. The revenue R , in dollars , made by selling x items is given by the equation R = 10x. How many items must the company sell in order for the cost to equal their revenue?
Meg's Manufacturing Company can make 211 units of a component part for variable costs of $159,896 and fixed costs of $32,104. The compnay decides the buy the part externally instead for $153,734 and $4,789 of the fixed costs will be avoided. How much will net income increase or decrease? If net income increases, make your answer positive; If net income decreases, put a (-) negative sign in front of the answer. Round your answer to the nearest whole dollar and do not type the dollar sign.
Milden Company is a distributor who wants to start using a contribution format income statement for planning purposes. The company has analyzed its expenses and developed the following cost formulas: Cost Cost Formula Cost of good sold $28 per unit sold Advertising expense $178,000 per quarter Sales commissions 6% of sales Shipping expense ? Administrative salaries $88,000 per quarter Insurance expense $9,800 per quarter Depreciation expense $58,000 per quarter Because shipping expense is a mixed cost, the company needs to estimate the variable shipping expense per unit sold and the fixed shipping expense per quarter using the following data: Quarter Units Sold ShippingExpense Year 1: First 24,000 $ 168,000 Second 26,000 $ 183,000 Third 31,000 $ 225,000 Fourth 27,000 $ 188,000 Year 2: First 25,000 $ 178,000 Second 28,000 $ 193,000 Third 38,400 $ 240,000 Fourth 35,400 $ 216,000 Required: 1.…
Novelli's Nursery has developed the following data in order to calculate the lower of cost or net realizable value for its products. The individual products are listed within the categories of trees. SellingPrice Cost Broad leaf trees: Ash $ 2,080 $ 1,620 Beech 2,620 1,520 Needle leaf trees: Cedar $ 3,060 $ 1,670 Fir 4,300 3,270 Fruit trees: Apple $ 2,080 $ 1,320 Cherry 2,720 1,720 The costs to sell are 10% of selling price. Required:Determine the reported inventory value assuming the lower of cost or net realizable value rule is applied to categories of trees. Product Cost NRV Lower of Cost or NRV Ash Beech Broad leaf trees Cedar Fir Needle leaf trees Apple Cherry Fruit trees Inventory value
The controller for the Lillian Corporation created an Excel worksheet that included a profit calculation. The worksheet also contained a data table created using the What-if analysis tool to analyze the sales price, volume, and profit related to the graphics card the company manufactures. The worksheets are pictured next. Profit calculation 2 Sales price per unit $50 3 Less: Variable cost per unit $20 4 Contribution margin per unit $30 5 × Volume 700 6 Total contribution margin $21,000 7 Less: Fixed expenses $12,000 8 Operating income $9,000 9 10 Monthly target profit (minimum) $9,999 Data table 2 $9,000 $45 $50 $55 $60 $65 $70 3 900 $10,500 $15,000 $19,500 $24,000 $28,500 $33,000 4 850 $9,250 $13,500 $17,750 $22,000 $26,250 $30,500 5 800 $8,000 $12,000 $16,000 $20,000 $24,000 $28,000 6 750…
The controller for the Lillian Corporation created an Excel worksheet that included a profit calculation. The worksheet also contained a data table created using the What-if analysis tool to analyze the sales price, volume, and profit related to the graphics card the company manufactures. The worksheets are pictured next. Profit calculation 2 Sales price per unit $50 3 Less: Variable cost per unit $20 4 Contribution margin per unit $30 5 × Volume 700 6 Total contribution margin $21,000 7 Less: Fixed expenses $12,000 8 Operating income $9,000 9 10 Monthly target profit (minimum) $9,999 Data table 2 $9,000 $45 $50 $55 $60 $65 $70 3 900 $10,500 $15,000 $19,500 $24,000 $28,500 $33,000 4 850 $9,250 $13,500 $17,750 $22,000 $26,250 $30,500 5 800 $8,000 $12,000 $16,000 $20,000 $24,000 $28,000 6 750…
Christabella, daughter of John Milton, produces and sells self-help kits to siblings to put away differences between them so siblings can work towards common goals. Last year, Christabella sold 198,400 kits (units). The income statement for Christabella, for last year is as follows: Sales $992,000 Less: Variable expenses 545,600 Contribution margin $446,400 Less: Fixed expenses 180,000 Operating income $266,400 a. Compute the break-even point in units and in revenues. Compute the margin of safety in sales revenue for last year. b. Suppose that the selling price decreases by 8 percent. Will the break-even point increase or decrease? Recompute the break-even point in units. (Round up to the nearest whole unit.) c. Suppose that the variable cost per unit decreases by $0.20. Will the break-even point increase or decrease? Recompute the break-even point in units. (Round up to the nearest whole unit.) d. Can you predict whether the break-even point increases or decreases if both the selling…
To help in the analysis, Kaylin gathered the following data for LLHC for 20X1: Tons sold: 10 Average cartons per shipment: 2 Average shipments per ton: 7 1) Using the new costs computed in Requirement 2, compute the profit per ton of LLHC. Compare this with the profit per ton computed by using the old method. Do you think that this same effect would be realized for other low-volume products? Explain.
Novelli's Nursery has developed the following data in order to calculate the lower of cost or net realizable value for its products. The individual products are listed within the categories of trees. SellingPrice Cost Broad leaf trees: Ash $ 1,860 $ 1,760 Beech 2,290 1,660 Needle leaf trees: Cedar $ 2,620 $ 1,810 Fir 3,450 3,410 Fruit trees: Apple $ 1,860 $ 1,460 Cherry 2,390 1,860 The costs to sell are 10% of selling price. Required:Determine the reported inventory value assuming the lower of cost or net realizable value rule is applied to individual trees. Product Cost NRV Lower of Cost or NRV Ash Beech Cedar Fir Apple Cherry Inventory value
Tucker Tucker makes and sells three products as follows: T K R £ £ £ Selling price 800 900 700 Material 215 250 180 Labour 110 120 95 Variable overheads 245 242.50 195 Fixed overheads 200 250 200 Profit 30 37.50 30 Budgeted sales 80 80 70 Total fixed costs have been absorbed on a unit basis according to the budgeted production. Calculate the break-even in both units and sales revenue and the margin of safety if Tucker sells its three products in the same ratio as the budgeted sales. Determine the production plan to break even with the least number of items.
Looking for the break-even point from the information provided. The Smiths need to develop an analysis of their breakeven point for the plastic display case based on sales of the product directly to the consumer as well as through retailers. If the product were sold to retailers, the price would have to provide retailers with an adequate markup. Exhibit C7.4 presents the expected cost structure for the Unique Display Cases display case developed by their accountant. Based on competitive prices, the Smiths expected to offer their product in direct to consumer sales for $24.99 plus $2.99 for shipping and handling. The price to retailers would have to be negotiated but would be 30–40% less to allow an adequate markup for the retail firms. The production cost of $7.50 was based on a production run of 5000 units in one color. At 10,000 or more units, production cost would drop to $5.75 per unit. The company that would produce the plastic unit had production capacity of 25,000 units a year.…