Question

In: Accounting

Karen’s Restaurant has three sales revenue departments with direct costs and average monthly figures given in...

Karen’s Restaurant has three sales revenue departments with direct costs and average monthly figures given in the following information:

Departments

Dining

Banquets

Beverages

Sales revenue

$306,000

$165,000

$138,000

Cost of sales

$122,400

$62,700

$44,160

Wages and salaries cost

$97,920

$52,800

$19,320

Other direct costs

$27,540

$13,200

$2,760

The restaurant also has the following indirect, undistributed costs:

Administrative and general expenses       $18,000

Marketing expenses               $15,000

Utilities expense                   $ 7,500

Property operation and maintenance       $18,180

Depreciation expense               $21,000

Insurance expense               $ 6,000

Required:

Prepare a consolidated departmental contributory income statement showing each of the three divisions side by side for comparison. Do not allocate indirect costs.

Allocate the indirect costs to the divisions side by side for comparison. Administrative, general, and marketing costs are allocated based on sales revenue. The remaining indirect costs are allocated based on square footage used by each division: Round all percentage calculations to a whole percentage.

Dining 3,600 sq. ft.   Banquet 4,500 sq. ft.   Beverage 900 sq. ft.

After allocating the indirect costs, would you consider closing any of the divisions? Why or why not?

Calculate the contributory income percentage for each of the three divisions.

Calculate the cost of sales, wages and salaries costs, and other direct costs as a percentage of sales revenue for each of the divisions.

If there were a shift of $12,000 in sales revenue from the banquet area to the dining room, would you expect the restaurant’s overall operating income to increase or decrease? Explain your reasoning to support your answer.

Assuming that the shift of $12,000 of sales revenue does occur, total sales revenue will not change. Total indirect, undistributed costs will not change. Recalculate cost of sales, wages and salaries costs, and other direct costs for each division (using the percentages in 5 above) to find the new departmental operating income.

After allocating the indirect costs, would you now consider closing any of the divisions? Why or why not?

Solutions

Expert Solution


Related Solutions

Tacoma Hospital has three support departments and four patient services departments. The direct costs to each...
Tacoma Hospital has three support departments and four patient services departments. The direct costs to each of the support departments are as follows: Tacoma Hospital has three support departments and four patient services departments. The direct costs to each of the support departments are as follows: Direct Costs Cost Driver General Administration $2,000,000 Salary Dollars Facilities $5,000,000 Housekeeping Labor Hours Financial Services $3,000,000 Patient Services Revenue Total $10,000,000 The patient services revenue, salary dollars, and housekeeping labor hours for each...
In order to allocate service departments' costs to production departments, there are three allocation methods (direct,...
In order to allocate service departments' costs to production departments, there are three allocation methods (direct, step-down, and reciprocal). Use your own example to show the calculation and difference among these methods.
A firm has monthly average costs, in dollars, given by C = 42,000 x + 200...
A firm has monthly average costs, in dollars, given by C = 42,000 x + 200 + x where x is the number of units produced per month. The firm can sell its product in a competitive market for $1800 per unit. If production is limited to 400 units per month, find the number of units that gives maximum profit. x =  units Find the maximum profit. $  
Fox Valley Health Care Facilities has three Revenue Producing Departments and four Non-Revenue Producing departments with...
Fox Valley Health Care Facilities has three Revenue Producing Departments and four Non-Revenue Producing departments with the data and costs as follows: Departments Costs Cost Driver Administration $200,000 Direct costs Maintenance 300,000 Square Feet Purchasing 250,000 Number of Purchase Orders Dietary 200,000 Number of Meals Sunny Vale Nursing Home 500,000 Revenue Producing – N/A In-Patient 600,000 Revenue Producing – N/A Out-Patient 210,000 Revenue Producing – N/A Cost Driver Data Departments Square feet Purchase Orders Meals Served Administration 1,200 1,600 200...
Fox Valley Health Care Facilities has three Revenue Producing Departments and four Non-Revenue Producing departments with...
Fox Valley Health Care Facilities has three Revenue Producing Departments and four Non-Revenue Producing departments with the data and costs as follows: Departments Costs Cost Driver Administration $200,000 Direct costs Maintenance 300,000 Square Feet Purchasing 250,000 Number of Purchase Orders Dietary 200,000 Number of Meals Sunny Vale Nursing Home 500,000 Revenue Producing – N/A In-Patient 600,000 Revenue Producing – N/A Out-Patient 210,000 Revenue Producing – N/A Cost Driver Data Departments Square feet Purchase Orders Meals Served Administration 1,200 1,600 200...
Classifying costs; direct costs: restaurant Indicate whether each of the following costs is a direct cost...
Classifying costs; direct costs: restaurant Indicate whether each of the following costs is a direct cost for an individual franchise of a gourmet pizza chain, providing reasons to explain your answer: (a) cost of food served (b) pizza chef’s salary and labour on-costs (c) costs allocated to each franchise for head office design of the standard pizza menu (d) shared costs for franchise marketing, which is managed by the franchise head office (e) depreciation on the wood-fired oven (f) cost...
Wayne’s Workshop shows average revenue per customer of $400. Monthly fixed costs are $40,000. Variable costs...
Wayne’s Workshop shows average revenue per customer of $400. Monthly fixed costs are $40,000. Variable costs in the last month were in total $32,000. During that month the workshop had 1,200 customers. Required 1.       Calculate the contribution margin ratio. 2.       Calculate the breakeven point. 3.       What was the profit last month? 4.       Prepare an income statement for last month using the contribution format. 5.       What was the operating leverage? 6.       Using the operating leverage formula, calculate the new operating income if sales fall by 5%.
6.      Hernandez Tool and Die has three service? departments: Budgeted Department Costs Cafeteria, revenue of $70,000 less...
6.      Hernandez Tool and Die has three service? departments: Budgeted Department Costs Cafeteria, revenue of $70,000 less expenses of $210,000 $140,000 Engineering 1,900,000 General factory administration 850,000 Cost-allocation bases are budgeted as? follows: Engineering Hours Production Worked for Production Total Labor Departments Employees Departments Hours Machining 126 47,600 299,000 Assembly 455 25,500 713,000 Finishing and painting 119 11,900 138,000 1.      Supposed Hernandez allocates all service department costs directly to the production departments without allocation to other service departments. How much of the...
1) Aday’s Restaurant has the following income statement: Revenue:    Food Sales                         
1) Aday’s Restaurant has the following income statement: Revenue:    Food Sales                          $240,000    Beverage Sales                        $86,000 Total Sales               $326,000 Cost of Sales:    Food Costs                $72,000    Beverage Costs             $15,480 Total Costs                 $87,480 Gross Profit              $238,520 Expenses:    Operating            $8,000    Labor                $26,000    Miscellaneous        $4,000    Administrative       $14,000 Total Expenses            $52,000 NET PROFIT                $186,520 Calculate administrative expenses as a % of sales          Select one: a. 3.00% b. 10.00% c. 1.23% d. 4.29% 2) Smitty’s Place recorded the following information from its lunch period on May...
Westside produces pillows with monthly unit sales and costs given as:  Unit Sales: 4000 units...
Westside produces pillows with monthly unit sales and costs given as:  Unit Sales: 4000 units  Price: $10.00 per unit  Variable costs: $5.50 per unit  Fixed costs: $15,000 1. Westside is considering a 5% price cut without additional fixed cost. By what % would sales need to increase to keep profit constant for the 5% price cut? 2. Replacing goose feathers with synthetic filler will decrease the unit variable cost by $0.22. By what % would sales...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT