Total sales $120,000 Food & Beverage $24,000 Total expenses $84,000 Cost of Food and Beverage based...

Total sales $120,000

Food & Beverage $24,000

Total expenses $84,000

Cost of Food and Beverage based on total sale (total sale * percentage = cost of food and beverage)

What percentage of Cost of Food and Beverage is needed to increase the Battle of the Chefs event's net profit by 10%?

(Hint: Create a formula to calculate the 10% increase, then use Goal Seek.)

Expert Solution

Solution:

ercentage of Cost of Food and Beverage is needed = 17%

ekkarill92 answered 1 year ago

1). Contribution Margin is: a). Sales - Total Variable expenses b). Sales - Total variable expenses...

1). Contribution Margin is: a). Sales - Total Variable expenses b). Sales - Total variable expenses - Total fixed expenses c). Sales revenue per unit x Sales quantity d). Variable expense per unit x Sales quantity 2). When preparing segmented income statements fixed expense are separated into the following categories: a). Traceable and common b).Fixed and Variable c).Direct and indirect d).Product and period 3).A Co. reported: Sales $125000; Contribution margin $62000; Total fixed expenses $42000; Common fixed expenses $15000. How...

Food sales $ 950,000 Other revenue 5% of total revenue Expenses: Fixed Variable* Labor $

Food sales $ 950,000 Other revenue 5% of total revenue Expenses: Fixed Variable* Labor $ 100,000 10% Cost of sales $ - 35% Supplies $ - 5% Energy $ 12,000 3% Marketing $ 5,000 4% Maintenance $ 12,000 2% Property taxes $ 4,000 Depreciation $ 15,000 Property insurance $ 5,000 Rent $ 3,500 * As a percentage of food sales. The Robinson Diner, managed by Ina Fay, needs your assistance in preparing its 20X8 operating budget. Since the diner is a sole proprietorship, it will not pay income taxes. Information is...

Strip Plank Parquet Total Sales revenue $400,000 $200,000 $300,000 $900,000 Less: Variable expenses 225,000 120,000 250,000...

Strip Plank Parquet Total Sales revenue $400,000 $200,000 $300,000 $900,000 Less: Variable expenses 225,000 120,000 250,000 595,000 Contribution margin $175,000 $ 80,000 $ 50,000 $305,000 Less direct fixed expenses: Machine rent (5,000) (20,000) (30,000) (55,000) Supervision (15,000) (10,000) (5,000) (30,000) Depreciation (35,000) (10,000) (25,000) (70,000) Segment margin $120,000 $ 40,000 $ (10,000) $150,000 Hickory's management is deciding whether to keep or drop the parquet product line. Hickory's parquet flooring product line has a contribution margin of $50,000 (sales of $300,000...

Miller Company’s total sales are $120,000. The company’s direct labor cost is $15,000, which represents 30%...

Miller Company’s total sales are $120,000. The company’s direct labor cost is $15,000, which represents 30% of its total conversion cost and 40% of its total prime cost. Its total selling and administrative expense is $18,000 and its only variable selling and administrative expense is a sales commission of 5% of sales. The company maintains no beginning or ending inventories and its manufacturing overhead costs are entirely fixed costs. Required: 1. What is the total manufacturing overhead cost? 2. What...

1) Below is last month's income statement for Aday’s Taqueria: Sales: Food Sales $42,500.00 Beverage Sales...

1) Below is last month's income statement for Aday’s Taqueria: Sales: Food Sales $42,500.00 Beverage Sales $21,500.00 Total Sales $64,000.00 Less Costs Of Sales: Food Costs $14,450.00 Beverage Costs $3,010.00 Gross Profit $46,540.00 Less Expenses: Insurance $2,500.00 Rent $3,000.00 Labor $18,000.00 Miscellaneous $1,400.00 Utilities $1,600.00 Advertising $2,400.00 Office Supplies $800.00 Depreciation $2,000.00 $31,700.00 Net Profit $14,840.00 The managers at ACME Factory have decided to classify costs as follows: 1. All of Insurance, Rent, Advertising and Depreciation as Fixed Costs. 2. All of...

Presented here is the income statement for Fairchild Co. for March: Sales $ 84,000 Cost of...

Presented here is the income statement for Fairchild Co. for March: Sales $ 84,000 Cost of goods sold 40,500 Gross profit $ 43,500 Operating expenses 30,500 Operating income $ 13,000 Based on an analysis of cost behavior patterns, it has been determined that the company's contribution margin ratio is 34%. Required: a. Rearrange the preceding income statement to the contribution margin format. Calculate operating income if sales volume increases by 6%. (Do not round intermediate calculations. Calculate the amount of...

The chief cost accountant for Kenner Beverage Co. estimated that total factory overhead cost for the...

The chief cost accountant for Kenner Beverage Co. estimated that total factory overhead cost for the Blending Department for the coming fiscal year beginning May 1 would be $210,000 and total direct labor costs would be $150,000. During May, the actual direct labor cost totaled $12,000 and factory overhead cost incurred totaled $17,100. Required: A. What is the predetermined factory overhead rate based on direct labor cost? B. On May 31, journalize the entry to apply factory overhead to production....

The cost accountant for River Rock Beverage Co. estimated that total factory overhead cost for the...

The cost accountant for River Rock Beverage Co. estimated that total factory overhead cost for the Blending Department for the coming fiscal year beginning February 1 would be $130,000, and total direct labor costs would be $100,000. During February, the actual direct labor cost totaled $12,500, and factory overhead cost incurred totaled $16,750. Required: a. What is the predetermined factory overhead rate based on direct labor cost? b. Journalize the entry to apply factory overhead to production for February 28....

In two companies making the same product and with the same total sales and total expenses,...

In two companies making the same product and with the same total sales and total expenses, the contribution margin ratio will be higher in the company with a higher proportion of fixed expenses in its cost structure. True False

Lone Star Sales & Service acquired a new machine that cost $84,000 in early 2019. The...

Lone Star Sales & Service acquired a new machine that cost $84,000 in early 2019. The machine is expected to have a five-year useful life and is estimated to have a salvage value of $14,000 at the end of its life. (Round your final answers to the nearest dollar.) (a.) Using the straight-line depreciation method, calculate the depreciation expense to be recognized in the second year of the machine's life and calculate the accumulated depreciation after the third year of...

Question