Sales Mix Analysis Delving further into the operations, another branch which is in the restaurant business is brought into focus. Management desires a net income of $ 135,000 from this division which has fixed costs of $ 300,000 per year. The following information about the operations of the division for the past two years has been supplied. (please refer to image) You are required to prepare a report to show : 1. The total sales required to achieve the desired net income 2. The total sales of each product required to meet the objectiv

Sales Mix Analysis Delving further into the operations, another branch which is in the restaurant business is brought into focus. Management desires a net income of $ 135,000 from this division which has fixed costs of $ 300,000 per year. The following information about the operations of the division for the past two years has been supplied. (please refer to image) You are required to prepare a report to show : 1. The total sales required to achieve the desired net income 2. The total sales of each product required to meet the objectiv

Entrepreneurial Finance

6th Edition

ISBN:9781337635653

Author:Leach

Publisher:Leach

Chapter5: Evaluating Operating And Financial Performance

Section: Chapter Questions

Problem 16DQ

See similar textbooks

Similar questions

The Beach Umbrella is a take-out food store at a popular beach resort. Susan Miller, owner of the Beach Umbrella, is deciding how much refrigerator space to devote to four different drinks. Pertinent data on these four drinks are as follows: (Click to view the data.) Miller has a maximum front shelf space of 12 feet to devote to the four drinks. She wants a minimum of 1 foot and a maximum of 6 feet of front shelf space for each drink. Read the requirements. Requirement 1. Calculate the contribution margin per case of each type of drink. Selling price per case Variable cost per case Contribution margin per case Requirements $ Cola Lemonade 18.25 $ 14.40 20.75 $ 15.60 Punch 27.70 $ 20.10 Natural Orange Juice 39.25 30.40 1. Calculate the contribution margin per case of each type of drink. 2. A coworker of Miller's recommends that she maximize the shelf space devoted to those drinks with the highest contribution margin per case. Do you agree with this recommendation? Explain briefly. 3.…
Compute the sales and food costs for the volumes below from the following data menu price $12.00 Food cost $3.60 cover sales food costs 1 10 50
891.687 157,356 312.090 39.339 257,016 162,602 149,294 Food Sales Beverage Sales Total Sales Food Cost Beverage Cost Total Cost of Sales Gross Profit Labor Cost Other operating Overhead Total Expenses Profit (Net Income) What is the food cost percentage? A. 33% B. 2.98% O C. 35% O D.36% Click Save and Submit to save and submit. Click Save All Answers to save
Cleveland Foods Data Note: You can download the Excel file containing Cleveland Foods' data by clicking the above link and perform the necessary calculations for answering the upcoming questions. Question 12 (1 point) □ What is the unit contribution of BlueLiq, considering the given information? $0.70 $2.50 $ 1.00 $1.70 $ $ J 0 20% Retail Margin 2.50 Price to consumers (Retail Price) 15% Wholesale Margin 2.00 Price to retailers (Wholesale Price) $ 1.70 Price to Wholesalers Variable Costs $ 0.70 per unit Fixed Costs Variable Manufacturing Costs $300,000 annual $200,000 Corporate Overhead $250,000 Marketing and Advertising $750,000 Total Fixed Costs Cleveland Foods Data Fixed Manufacturing Costs Note: You can download the Excel file containing Cleveland Foods' data by clicking the above link and perform the necessary calculations for answering the upcoming questions. Question 11 (1 point). Listen 4 What is the price at which Cleveland Foods sells BlueLiq to wholesalers? $1.70 $2.50 $1.00
Multiplication table: 1. Quantity ordered Percentage of Discount Less than 100 units 5 % 101-150 units 10% 151-200 units 15% 201-250 units 20% 251units and above 25% With reference to the above table, if a cumulative discount was given by JJ Cake Pastries to Ace Catering for twenty dozens of cupcakes, priced at P25.00 per unit for orders within one month. Total amount payable is P________ if orders are as follow: November 6, 2020 - 5 dozens November 8, 2020 - 10 dozens November 15, 2020 - 10 dozens November 20, 2020 - 8 dozensa. 7,425 b.7,920 c.8,910 d.8,415 2. William is the owner of a company that specializes in the manufacturing of office computers and printers. He recently received a large order from a company…
Calculate the sales and food costs for the volumes below from the following data: Menu Price $12.00 Food Cost 3.60 Covers Sales Food Cost 1 . . 10 . . 50 . .
Given the information below, calculate BEVERAGE COST PERCENTAGE: SALES Food Beverage Total Sales COST OF SALES Food Beverage Total Cost of Sales a) 26.75% b) 10.24% c) 34.68% d) 21.48% This Month $68,750 42,630 $111,380 man $21,484 $11,404 $32,888 % of sales
National Beverages company estimated the sales as follows Al Dahirah ( in units ) Al Batinah (In units ) Soft drinks 200,000 250,000 Mineral water 50,000 80,000 Assumed that selling price of Soft drinks OMR 0.250 Bz and Mineral water OMR 0.100 Bz., Estimate the total sales in volume. a. OMR 580,000 b. 58,000 Units c. 580,000 Units d. 55,000 Units
Shopmart is an international retail store. Shopmart's managers are considering implementing a new business-to-business (B2B) information system for processing merchandise orders. The current system costs Shopmart $2,500,000 per month and $45 per order. Shopmart has two options, a partially automated B2B and a fully automated B2B system. The partially automated B2B system will have a fixed cost of $15,000,000 per month and a variable cost of $35 per order. The fully automated B2B system has a fixed cost of $33,000,000 per month and a variable cost of $20 per order. Based on data from the past 2 years, Shopmart has determined the following distribution on monthly orders: (Click the icon to view the data.) Read the requirements. Order level 300,000 orders 500.000 orders Current plan Total monthly cost of orders *** x Probability X = m Total expected cost of orders A
Given the constant profit margin of 25%, determine the primary or net income for each SKU. Type your answers below. Note: 5th column is for RETURNS FROM CUSTOMERS due to product damages and defects. SKUS QUANTITY SELLING RETURNS NET SOLD PRICE FROM INCOME 1 SPRITE 2L 67 95.00 4 SPRITE 1.5L SPRITE 1L SPRITE 500ML SPRITE 355ML CAN CBTL COFFEE MOCHA 3-in-1 NESCAFE MOCHA LATTE 3-in-1 SAN MIG SUGAR FREE COFFEE 3-in-1 SWISS MISS DARK COCOA MIX 3-in-1 10 SWISS MISS MALLOWS COCOA MIX 3-in-1 2 101 70.00 7 3 59 50.00 4 45 25.00 70 25.00 3 42 30.00 2 7 55 15.00 3 8 90 10.00 5 9. 35 14.00 1 59 12.00 4
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
Problem 1What is the standard recipe adjustment factor, given the following information? original recipe New recipe AF Number of protion Portion size Number of portion Portion size 35 .25 cup 75 .25cup 75 4oz 35 4oz 35 .5cup 35 .25cup 75 6oz 75 10oz 35 6oz 75 8oz 75 .5cup 35 .25cup Problem 2 Determine the portion cost for the steak platter based upon the following information: 4oz sirloin $10.15/lb 1 baked potato 12 potatoes for $3.70 1oz sour cream 5lb jar for $7.15 2 dinner rolls $3.85 dozen 4 oz corn 5lb for $5.75 Problem 3 Calculate the Contribution Margin (CM) and Food Cost % given the following data: Item No sold Revenue food cost CM Food Cost % A 25 180 45 B 40 230 62 C 45 300 90 D 20 340 100