Cleveland Foods Data Note: You can downloadthe Excel file containing Cleveland Foods' databy clicking the above link and perform thenecessary calculations for answering theupcoming questions. Question 12 (1 point) □What is the unit contribution of BlueLiq,considering the given information? $0.70 $2.50 $1.00 $1.70$$J020% Retail Margin2.50 Price to consumers (Retail Price)15% Wholesale Margin2.00 Price to retailers (Wholesale Price)$1.70 Price to WholesalersVariable Costs$ 0.70 per unitFixed CostsVariable Manufacturing Costs$300,000 annual$200,000 Corporate Overhead$250,000 Marketing and Advertising$750,000 Total Fixed CostsCleveland Foods DataFixed Manufacturing CostsNote: You can download the Excel file containing Cleveland Foods' data by clickingthe above link and perform the necessary calculations for answering the upcomingquestions.Question 11 (1 point).Listen4What is the price at which Cleveland Foods sells BlueLiq to wholesalers?$1.70$2.50$1.00

The question asks you to find the price at which Cleveland Foods sells blue licorice to wholesalers.…

Answered: Cleveland Foods Data Note: You can…

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter18: Cost-volume-profit Analysis (cvp)

Section: Chapter Questions

Problem 2R: Open the file CVP from the website for this book at cengagebrain.com. Enter the formulas where...

See similar textbooks

Similar questions

b) Write Excel Formulas for given data sheet A B D E 1 Product Product Price per Sales tax(10% |Net Price No item of price) ? name 2 1 Mouse 5000 keyboard joyStick 3 1000 4 3 1500 4 VGA cable 800 6. Monitor 15000 Total price of all items 5% concession on total price 7 ? 8 ? 9. Total bill ? Dage 213
Type the formulas to calculate the following: In cell B9, calculate the grand total amount owing for all customers. In ce E KBC DFGHJ1 Cost Retail 2 Mussels R12,40 R21, 70 3 Crabs R25, 60 R44,804 Markup % 75,0% 5 Discount % 8,5% EFT 6 VAT % 15 89 Total Sales 10 Cost of Sales 11 Profit or Loss No of 12 Customers No of Crab 13 Customers Sales of Mussel 14 Customers 15 Can
Assume that markup is based on selling price. Calculate the dollar markup and cost. (Round your answers to the nearest cent.) Selling price Dollar Item Markup percent Cost markup Canon scanner 2$ 105 40 %
igmeniMalh.do?invoker=&takeAssignmentSessionLocator=&inprogress%3Dfalse Show Me How Print Item eBook Contribution Margin and Contribution Margin Ratio For a recent year, McDonald's (MCD) company-owned restaurants had the following sales and expenses (in millions): Sales $15,295.0 Food and packaging $(4,896.9) Payroll (4,134.2) Occupancy (rent, depreciation, etc.) (3,667.7) General, selling, and administrative expenses (2,384.5) $(15,083.3) Operating income $211.7 Assume that the variable costs consist of food and packaging, payroll, and 40% of the general, selling, and administrative expenses. a. What is McDonald's contribution margin? Round to the nearest tenth of a million (one decimal place). million b. What is McDonald's contribution margin ratio? Round to one decimal place. % c. How much would operating income increase if same-store sales increased by $800 million for the coming year, with no change in the contribution margin ratio or fixed costs? Round your answer to the nearest…
QUESTION 6 Use the information below to answer. If total sales are $18,800 what is the MD%? Style # QTY Orig Retail Sale Price 1000 120 $50.00 $29.99 1200 150 $38.00 $29.99 1300 144 $44.00 $29.99 1400 96 $54.00 $29.99
Complete the following table: (Do not round intermediate calculations. Round your final answers to the nearest cent.) Chain Trade Item List price discount Net price discount Sony digital camera 331 4/2/6 ......... M %24
Open the file CVP from the website for this book at cengagebrain.com. Enter the formulas where indicated on the worksheet. Enter your name in cell A1. Save the solution as CVP2 and print the worksheet. Also print your formulas. Check figures: Break-even point in sales dollars (cell C35), 1,616,000; Net income (cell C38), 95,000.
Assume that markup is based on cost. Calculate the cost and selling price. Note: Round your answers to the nearest cent. Cost Selling price Dollar markup $ 6.00 Percent markup on cost 101.69 %
Jordan Cameras, Incorporated manufactures two models of cameras. Model ZM has a zoom lens; Model DS has a fixed lens. Jordan uses an activity-based costing system. The following are the relevant cost data for the previous month: Direct Cost per Unit Direct materials Direct labor Category Unit level Batch level Product level Facility level Total Estimated Cost $ 25,960 49,920 90,000 180,000 $ 345,880 Model ZM $ 20.70 29.40 Cost Driver Model DS $7.00 9.00 Number of units Number of setups Number of TV commercials Number of machine hours Amount of Cost Driver ZM: 2,500 units; DS: 9,300 units ZM: 26 setups; DS: 26 setups ZM: 14; DS: 11 ZM: 300 hours; DS: 600 hours Jordan's facility has the capacity to operate 2,700 machine hours per month. Required a. Compute the cost per unit for each product. b. The current market price for products comparable to Model ZM is $118 and for DS is $68. If Jordan sold all of its products at the market prices, what was its profit or loss for the previous month?…
Calculate total revenue and fill in the table below. Price Quantity Total Revenue S50 60 $40 06 $35 110 S30 140 $25 190
Complete this question by entering your answers in the tabs below. Req 1A Req 1B Req 2A Req 2B Assuming the sales mix given above, prepare a contribution format income statement showing both dollar and percent columns for e for the company as a whole. $ Island Novelties, Inc., Contribution Income Statement Hawaiian Fantasy Amount % 0 % % 0% $ Total Amount 0 0 % % % 0 %
Using the decision-making grid below, calculate the total score for Appliance "A." Appliance A Criteria Decision Weight (W) Score (S) WxS Price 30% 6 Durability 25% 8 Features 20% 8 Warranty 15% 7 Styling 10% 9 TOTAL 100%

SEE MORE QUESTIONS

Recommended textbooks for you

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS