Question

In: Accounting

Cost Behavior Assume a local pizzeria reported the following results for June and July April May...

Cost Behavior
Assume a local pizzeria reported the following results for June and July
April May
Unit Sales      2,000      3,000
Cost of Food Sold $   8,000 $ 12,000
Wages and Salaries      3,700      4,000
Rent      2,000      2,000
Depreciation         500         500
Utilities      1,400      1,500
Supplies         200         300
Total $ 15,800 $ 20,300
a. Identify each cost as being fixed, variable or mixed.
b. Determine the equation for total operating costs (Fixed + Unit Variable Cost * # of sandwiches)
c. Predict the total operating costs for 4000 pizzas
d. Determine the average costs for 4000 pizzas
Concept question: Why are fixed costs generally not relevant for decision-making?
Would average costs be useful for decision-making and why or why not?

Solutions

Expert Solution

Answer

April

May

Difference

Change %

Type of Cost

Unit Sales

      2,000

      3,000

        1,000

50%

Cost of Food Sold

$   8,000

      12,000

        4,000

50%

Variable

Wages and Salaries

      3,700

      4,000

          300

8.11%

Mixed

Rent

      2,000

      2,000

             -  

-

Fixed

Depreciation

         500

         500

             -  

-

Fixed

Utilities

      1,400

      1,500

          100

7.14%

Mixed

Supplies

         200

         300

          100

50%

Variable

Total

      15,800

      20,300

        4,500

I have calculated Difference and Change % as the difference will give us the Change and % change will tell us the Change in Production so if the Cost is Variable it will increase with same Percent and if there is no change in cost then it will be fixed cost and

If there is a increase but not the same percent as change in production then it means that the cost is mixed Cost.

Like in our question there is a increase of 50% in Unit sales, that means the variable cost should also increase by 50%, like in Supplies case, supplies is increasing by 50% same with change in sales, so it is a variable cost

And if there is not 50% increase then the cost is Mixed like Utilities is increasing by 7.14% not 50% so this is a fixed cost.

And if the cost is constant then it will be mixed like in Rent and Depreciation case, both are constant.

b.

Variable Cost = Total Difference / Change in sales

= $4,500 / 1000 Units

Variable Cost = $4.5 per unit

Fixed Cost = Total Cost – Variable cost

Let’s take example of 2,000 Units

Fixed Cost = $15,800 - $4.5 * 2,000 Units

Fixed Cost = $6,800

Y = $6,800 + $4.5x

Y = Total Cost

X = No. of Units

c.

Operating Cost for 4,000 Pizza = $6,800 + $4.5 * 4,000

Operating Cost for 4,000 Pizza = $24,800

d.

Average cost for 4,000 Pizza = Operating Cost for 4,000 Pizza / 4,000 Pizza

= $24,800 / 4,000 pizza

Average cost for 4,000 Pizza = $6.2 per pizza

e.

Fixed Cost is the cost which doesn’t gets affected by change in production or Change in sales, i.e. It remains same at all levels of production or sales.

So if we are trying to decide anything Fixed Cost doesn’t affect our Decision making process as Fixed Cost will be there and will be same, so if we produce 0 Units then also the Fixed Cost will be there and if we produce 1,000 Units then also the Fixed Cost will be there and same.

So Fixed Cost doesn’t affect our decision

f.

Yes we can say that Average Cost affect our decision as we know that the more units we produce the less will be the Average Cost as Fixed Cost is same and with increase in production, it is been divided between more units and thus leads to less per unit cost.

And if we want to decide something then the Per unit cost affects our decision.

Dear Student, if u have any doubt plz feel free to reach me.


Related Solutions

Ruiz Co. provides the following sales forecast for the next four months: April May June July...
Ruiz Co. provides the following sales forecast for the next four months: April May June July Sales (units) 680 760 710 800 The company wants to end each month with ending finished goods inventory equal to 20% of next month's forecasted sales. Finished goods inventory on April 1 is 136 units. Assume July's budgeted production is 710 units. In addition, each finished unit requires four pounds (lbs.) of raw materials and the company wants to end each month with raw...
Ruiz Co. provides the following sales forecast for the next four months: April May June July...
Ruiz Co. provides the following sales forecast for the next four months: April May June July Sales (units) 570 650 600 690 The company wants to end each month with ending finished goods inventory equal to 30% of next month's forecasted sales. Finished goods inventory on April 1 is 171 units. Assume July's budgeted production is 600 units. In addition, each finished unit requires four pounds (lbs.) of raw materials and the company wants to end each month with raw...
Ruiz Co. provides the following sales forecast for the next four months: April May June July...
Ruiz Co. provides the following sales forecast for the next four months: April May June July Sales (units) 630 710 660 750 The company wants to end each month with ending finished goods inventory equal to 30% of next month's forecasted sales. Finished goods inventory on April 1 is 189 units. Assume July's budgeted production is 660 units. In addition, each finished unit requires four pounds (lbs.) of raw materials and the company wants to end each month with raw...
Zira Co. reports the following production budget for the next four months. April May June July...
Zira Co. reports the following production budget for the next four months. April May June July Production (units) 654 695 687 667 Each finished unit requires five pounds of raw materials and the company wants to end each month with raw materials inventory equal to 30% of next month’s production needs. Beginning raw materials inventory for April was 981 pounds. Assume direct materials cost $3 per pound. Prepare a direct materials budget for April, May, and June. (Round your intermediate...
April May June July Sales 600,000 900,000 500,000 400,000 Cost of Goods sold 420,000 630,000 350,000...
April May June July Sales 600,000 900,000 500,000 400,000 Cost of Goods sold 420,000 630,000 350,000 280,000 Gross Margin 180,000 270,000 150,000 120,000 Selling and admin expenses selling expense 79,000 120,000 62,000 51,000 administrative 45,000 52,000 41,000 38,000 total selling and administrative expenses 124,000 172,000 103,000 89,000 net operating income 56,000 98,000 47,000 31,000 a. sales are 20% for cash and 80% on account b. sales on account are collected over a three month period with 10% collected in the...
month units total cost april 8000 27400 may 6400 25800 june 3800 18300 july 5600 23200...
month units total cost april 8000 27400 may 6400 25800 june 3800 18300 july 5600 23200 august 7000 26000 september 8400 29800 october 7800 26500 november 6800 25700 using the gleason products data from above perform a LEAST REGRESSION ANALYSIS on the data ( use excel to perform analysis) a) what is Gleasons total fixed cost? b) what is Gleasons varaiable cost per unit? c) what would total cost be for a month with 7500 units produced? d) what proportion...
XYZ Company reported the following information: June July Cost A $18,000 $0.20 per unit Cost B...
XYZ Company reported the following information: June July Cost A $18,000 $0.20 per unit Cost B $19,000 $29,800 Cost C $17,000 $0.34 per unit Units sold 50,000 units 90,000 units XYZ Company expects to sell 76,000 units in August at a selling price of $1.50 per unit Calculate the amount of net income XYZ Company would expect to earn in August.
Historical demand for a product is as follows: DEMAND April 61 May 56 June 81 July...
Historical demand for a product is as follows: DEMAND April 61 May 56 June 81 July 61 August 86 September 81 a. Using a simple four-month moving average, calculate a forecast for October. (Round your answer to 2 decimal places.) b. Using single exponential smoothing with α = 0.30 and a September forecast = 64, calculate a forecast for October. (Round your answer to 2 decimal places.) c. Using simple linear regression, calculate the trend line for the historical data....
Cave Hardware's forecasted sales for April; May; June; and July are $200,000; $230,000; $190,000; and $240,000;...
Cave Hardware's forecasted sales for April; May; June; and July are $200,000; $230,000; $190,000; and $240,000; respectively. Sales are 65% cash and 35% credit with all accounts receivables collected in the month following the sale. Cost of goods sold is 75%of sales and ending inventory is maintained at $60,000 plus 10% of the following month's cost of goods sold. All inventory purchases are paid 22% in the month of purchase and 78%in the following month. What are the cash collections...
Finish the following Cash Budget CASH BUDGET JAN FEB MAR APRIL MAY JUNE JULY AUG SEPT...
Finish the following Cash Budget CASH BUDGET JAN FEB MAR APRIL MAY JUNE JULY AUG SEPT OCT NOV DEC SALES 200,000 230,000 150000 210,000.00 220,000.00 170,000.00 160,000.00 150,000.00 180,000.00 210,000.00 220,000.00 210,000.00 COLLECTIONS: No cash Sales 30 days 50% 60 days 50% TOTAL CASH RECEIPTS CASH DISBURSEMENTS SUPPLIES 70% PAYABLES/SUPPLIES paid next month(in 30 days) SALARIES/OVER monthly 40000 INTEREST monthly 1000 DIVIDENDS monthly 1000 TAXES quarterly 1200 TOTAL DISBURSEMENT 42000 0 1200 0 0 0 0 0 0 0 0...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT