Question

In: Accounting

10. The following figures are from the accounting records of the Red Fox Inn, the restaurant...

10. The following figures are from the accounting records of the Red Fox Inn, the restaurant identified in Question 9:
Opening Inventory $7,414.80
Closing Inventory $6,327.35
Food Purchases $17,642.80
Transfers: Beverage to Food $443.00
Transfers Food to Beverage $226.00
Employees' Meals $837.00
a. Calculate cost of food sold for the month of March.
Cost of Food Sold
b. Using the information provided in Question 9, calculate each of the following:
Actual Cost %
Standard Cost %
Potential Savings $

Potential Savings as a % of Sales

9. The owner of the Red Fox Inn has developed a new menu for use in her establishment. Each menu item represents a complete meal. She has determined standard cost for each item and has kept careful records of sales for the month of March. The data are as follows:
Menu Item Number Sold Standard Portion Cost Total Cost
A 310 $5.50 $1,705.00
B 270 $7.80 $2,106.00
C 540 $3.80 $2,052.00
D 425 $5.25 $2,231.25
E 175 $8.70 $1,522.50
F 340 $6.50 $2,210.00
G 510 $5.70 $2,907.00
H 480 $4.20 $2,016.00
Total Standard Cost $16,749.75
Total Revenue $50,028.50
Total Standard Cost % 33.48%

Solutions

Expert Solution

(a.) Statement of cost of food sold (fig. in $)

Food purchases 17,642.80

Add: Opening Inventory 7,414.80

Transfers from beverage (Beverage to food) 443.00

Less: Closing Inventory 6327.35

Transfers to beverage (Food to beverage) 226.00

Employees' Meals 837.00

TOTAL 18110.25

Therefore, cost of food sold for the month is $ 18,110.25.

Transfers from beverages is added to cost while transfers to beverages is reduced from the cost.

Since the food stock utilised for employees' meals is not part of sales hence that portion of food will not be considered for calculating the cost of food sold.

(b.) Actual cost %

Actual cost is the cost actually incurred as we have calculated from the acounting records in the part (a.), i.e., $ 18,110.25.

Therefore, Actual cost % = Actual cost incurred/Revenue = 18,110.25/50028.50 = 36.2% (Revenue = $ 50,028.50)

  Standard cost %

Standard cost is the estimated or the budgeted cost which is calculated before the actual cost is incurred.

As given in Q9, Standard cost = $ 16,749.75 and Standard cost % = Standard cost/ Revenue = 16749.75/50028.50 = 33.48%

Potential savings

Potential savings = Revenue - Actual cost = 50,028.50 - 18,110.25 = 31,918.25

When we have the figure of actual cost, potential savings must be calculated by deducting actual cost from the total revenue. Therefore, Potential savings are $ 31,918.25.


Related Solutions

the following budgeted figures have been taken from the cost records of MZ ltd: production units...
the following budgeted figures have been taken from the cost records of MZ ltd: production units 10 000 12 500 capacity level 80% 100% sales R1 144 000 R1 430 000 direct material @R5 per KG R200 000 R250 000 direct labour @R20 per hour R240 000 R300 000 factory overheads R300 000 R330 000 selling and administrative expenses R180 000 R190 000 normal capacity is equal to 12 500 units. As a result of poor economic conditions the budget...
The following cost and inventory data are taken from the accounting records of a Company for...
The following cost and inventory data are taken from the accounting records of a Company for the year just completed: Costs incurred: Direct labor cost ................................................... $140,000 Purchases of raw materials .................................. $236,000 Manufacturing overhead ...................................... $160,000 Advertising expense ............................................. $180,000 Sales salaries ....................................................... $100,000 Depreciation, office equipment ............................ $6,000 Inventories: Beginning the Year End the Year Raw materials ............................ $14,000 $30,000 Work in process .......................... $20,000 $10,000 Finished goods ............................ $40,000 $70,000 Required: 1. Prepare the cost of goods...
The following cost and inventory data are taken from the accounting records of a Company for...
The following cost and inventory data are taken from the accounting records of a Company for the year just completed: Costs incurred: Direct labor cost ................................................... $140,000 Purchases of raw materials .................................. $236,000 Manufacturing overhead ...................................... $160,000 Advertising expense ............................................. $180,000 Sales salaries ....................................................... $100,000 Depreciation, office equipment ............................ $6,000 Inventories: Beginning the Year End the Year Raw materials ............................ $14,000 $30,000 Work in process .......................... $20,000 $10,000 Finished goods ............................ $40,000 $70,000 Required: 1. Prepare the cost of goods...
Please send the solutions for these numericals in Cost Accounting: 31. From the following figures, find...
Please send the solutions for these numericals in Cost Accounting: 31. From the following figures, find the break-even volume: Selling Price Per ton Rs. 69.50; Variable Cost per ton Rs. 35.50; Fixed Expenses Rs. 18.02 lakhs. If this volume represents 40% capacity, what is the additional profit for an added production of 40% capacity, the selling price of which is 10% lower for 20% capacity production and 15% lower, that the existing price for another 20% capacity; 32. From the...
The following data from the just completed year are taken from the accounting records of Mason...
The following data from the just completed year are taken from the accounting records of Mason Company:    Sales $ 650,000 Direct labor cost $ 81,000 Raw material purchases $ 137,000 Selling expenses $ 101,000 Administrative expenses $ 43,000 Manufacturing overhead applied to work in process $ 202,000 Actual manufacturing overhead costs $ 225,000 Inventories Beginning Ending Raw materials $ 8,400 $ 10,400 Work in process $ 5,100 $ 20,200 Finished goods $ 71,000 $ 25,900 Required: 1. Prepare a...
The following data from the just completed year are taken from the accounting records of Mason...
The following data from the just completed year are taken from the accounting records of Mason Company:    Sales $ 653,000 Direct labor cost $ 85,000 Raw material purchases $ 136,000 Selling expenses $ 110,000 Administrative expenses $ 45,000 Manufacturing overhead applied to work in process $ 208,000 Actual manufacturing overhead costs $ 221,000 Inventories Beginning Ending Raw materials $ 8,200 $ 10,300 Work in process $ 5,300 $ 20,000 Finished goods $ 75,000 $ 25,800 1. Prepare a schedule...
The following data from the just completed year are taken from the accounting records of Mason...
The following data from the just completed year are taken from the accounting records of Mason Company: Sales $ 656,000 Direct labor cost $ 86,000 Raw material purchases $ 132,000 Selling expenses $ 107,000 Administrative expenses $ 42,000 Manufacturing overhead applied to work in process $ 207,000 Actual manufacturing overhead costs $ 223,000 Inventories Beginning Ending Raw materials $ 8,100 $ 10,300 Work in process $ 5,800 $ 20,300 Finished goods $ 79,000 $ 25,400 Required: 1. Prepare a schedule...
The following data from the just completed year are taken from the accounting records of Mason...
The following data from the just completed year are taken from the accounting records of Mason Company:    Sales $ 653,000 Direct labor cost $ 87,000 Raw material purchases $ 132,000 Selling expenses $ 105,000 Administrative expenses $ 42,000 Manufacturing overhead applied to work in process $ 208,000 Actual manufacturing overhead costs $ 229,000 Inventories Beginning Ending Raw materials $ 9,000 $ 11,000 Work in process $ 5,100 $ 20,700 Finished goods $ 77,000 $ 25,400 Required: 1. Prepare a...
The following data from the just completed year are taken from the accounting records of Mason...
The following data from the just completed year are taken from the accounting records of Mason Company:    Sales $ 651,000 Direct labor cost $ 88,000 Raw material purchases $ 138,000 Selling expenses $ 103,000 Administrative expenses $ 48,000 Manufacturing overhead applied to work in process $ 206,000 Actual manufacturing overhead costs $ 228,000 Inventories Beginning Ending Raw materials $ 8,500 $ 10,900 Work in process $ 5,400 $ 20,000 Finished goods $ 76,000 $ 25,000 Required: 1. Prepare a...
The following data from the just completed year are taken from the accounting records of Mason...
The following data from the just completed year are taken from the accounting records of Mason Company:    Sales $ 656,000 Direct labor cost $ 80,000 Raw material purchases $ 137,000 Selling expenses $ 104,000 Administrative expenses $ 45,000 Manufacturing overhead applied to work in process $ 205,000 Actual manufacturing overhead costs $ 225,000 Inventories Beginning Ending Raw materials $ 8,200 $ 10,900 Work in process $ 5,600 $ 20,600 Finished goods $ 74,000 $ 25,200 Required: 1. Prepare a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT