Question
A Case Method Approach of Teaching how Cost-Volume-Profit Analysis is connected to the Flexible Budgeting Process and Variance Analysis To start a successful business, you
A Case Method Approach of Teaching how Cost-Volume-Profit Analysis is connected to the Flexible Budgeting Process and Variance Analysis
To start a successful business, you need to understand the steps necessary to achieve their desired profits.
INTRODUCTION
"We first present an alternative, more comprehensive teaching approach, for Cost-Volume-Profit (CVP) analysis from the commonly used approach which simply teaches students how to use a series of equations to solve various questions related to CVP analysis, in which unit selling price, total fixed costs, and unit variable costs are assumed to remain constant (Garrison et al., 2010; Choo and Tan, 2010). We use a multi-disciplinary approach in the context of a realistic case-analysis. We believe this approach offers useful insights and provides a useful learning tool for students pursuing an advanced Master's Degree." (Machuga, 2012). This case requires you to: (a) make assumptions about cost behavior in a dynamic and interactive way, and (b) research a variety of marketing issues for the proposed business that simulates a real life business situation, and (c) use the information from their CVP analysis for planning purposes, applying what they typically learn when they read about budgeting, and (d) compare the results of their business venture using the Income Statement prepared based on their planned level of sales volume to the results that should have occurred based on the actual level of sales volume, as well as the actual results we provide in the case. This allows you to see how budgets are used to develop goals, as well as to determine if actual results were achieved. This paper's approach emphasizes the importance of CVP analysis and how it ties directly into planning and control processes management must take in order to start a potentially successful business. More importantly, we show you the importance of these key practical yet very relevant management-accounting tools, all done in one integrative setting instead of teaching those concepts separately.
A very important concept for you to understand is whether they have accomplished profit goals they set in their CVP analysis. In other words, they need to understand how to take their assumptions from the first part of the case and use them to develop the necessary budgets in order to finally prepare a projected Income Statement. Budgets force management to plan for the future as does CVP analysis. In addition, preparing a number of budgets allows you to understand that in order accomplish their profit goal they must also prepare budgets to coordinate activities throughout the company. This case will allow you to understand how budgets can help them coordinate activities throughout the entire company by integrating material purchases' plans, and labor use, etc. Even more importantly, you will learn the importance of budgets and their use for evaluation and control purposes. Because the actual level of activity will most likely differ from the planned level of activity, we also require the you to prepare a Flexible budget. The Flexible budget allows them to understand the reason planned results differ from actual results in terms of activity variances versus revenues and spending variances (Horngren et al., 2012).
DEVELOPMENT OF THE CASE
"The case assumes you will open a milkshake shack on the beach of a resort on the "big Island" of Hawaii. I have studied existing restaurants, read industry reports, and have done some research on expected minimum costs to be incurred in operating the business. A unique feature of my milkshakes is that I will serve them with flavored straws that match the flavor of the chosen milkshakes by customers. My research embeds the following assumptions:" (see Machuga, 2012)
Sales prices of milkshakes ($7.00 for small, and $10.00 for large)
Cost of materials needed to make milkshakes:
DIRECT MATERIAL INGREDIENTS | Small (8 oz. size) | Large (12 oz. size) |
Whole Milk ($15 for a 5 gallon=640 oz.) | (need 2 oz. of milk) | (need 3 oz. of milk) |
Cream ($20 for 1 gallon=128 oz.) | (need 2 oz. of cream) | (need 3 oz. of cream) |
Sugar ($10 for a 15 lb. bag=30 cups) | (need cup of sugar) | (need cup of sugar) |
Premium Vanilla Ice Cream ($24 for 600 oz.) | (need 6 oz. of ice cream) | (need 9 oz. of ice cream) |
Flavorings | .25 per shake | .40 per shake |
Flavored specialty straws | .75 per straw | .75 per straw |
Cups (500 8 oz. cups @ a cost of $200) | ------------------------------- | |
Cups (500 12 oz. cups @ a cost of $250) | ---------------------------- |
Fixed costs:
- Shack rental: $500 a month
- Cleaning and other miscellaneous supplies: $100 a month
- Equipment: Industrial Milk Shake Maker: $72 per machine x 10 machines=$720
- Equipment: Industrial Refrigerator/freezer: $480
- Countertops: $1,200
- Tables and benches for customers to sit outside: $108 per bench-set x 10=$1,080
- Annual insurance: $600 a year
- Sign: use your marketing knowledge to think of a good name= $100
- Advertising expenses: $5,000 a month
- Accounting and bookkeeping costs: $500 a month
- Owner's salary: $96,000 a year
- Dues and membership fees: $2,000 a year.
- Licenses and permit fees: $600 a year.
- Maintenance services: $400 a month.
- Office supplies: $300 a month.
Employees:
- Twopart-time employees: each receiving a monthly salary of $800 (including benefits).
Total Start-up Costs = $20,247 for which you are assumed to take out a non-owner loan for the first months expenses and cost of long-term assets, which consist of the following amounts: ($500+$100+$720+$480+$1,200+$1,080+$50+$100+$5,000+$500+$8,000+$167+$50+$400+$300
+1,600=$20,247). A self-amortizing loan is assumed to be obtained from a bank, and carries an annual interest rate of 6% payable over 2 years with monthly payments (each monthly payment consists of both principal and interest). The loan amortization schedule is include in the appendix of this case study (first months interest expense is $101.24).
Other costs:
10% of gross sales must be given to resort where shack will be located on its premises.
Owner's capital will be used to cover direct materials' costs.
REQUIREMENTS OF THE FIRST PART OF THE CASE - which you already completed however I have given you the correct answer below:
ANSWERS TO THE FIRST PART OF THE CASE: Presented below is one possible answer to this case using only information provided in the case with the following assumptions: 1)the milkshake's sales-mix will be 60% large and 40% small, 2) the suggested sales prices are used to be competitive with other vendors, and 3) the milkshake makers, tables and benches are assumed to last for 3 years, but the refrigerator/freezer and counter tops are assumed to last for 10 years and the sign is assumed to last only one year. Since this is a simulation exercise, the case allows you to see how the break-even sales volume changes depending upon different assumptions about product sales-mix, sale prices, depreciable lives of long-term assets as well as variable costs, and allows them to add other necessary fixed costs to the cost structure of the business conditional on their own unique business strategy. Consequently, their answers may vary. Monthly fixed costs:
- Salary of 2 part-time workers 1,600.00
- Rental 500.00
- Supplies 100.00
- Milk Shake Maker depreciation 20.00 (720/ 36months)
- Refrigerator/freezer depreciation 4.00 (480/120 months)
- Counter tops depreciation 10.00 (1,200/120months)
- Tables and benches depreciation 30.00 (1,080/36 months)
- Annual insurance 50.00 (600/12months)
- Interest on loan 101.24
- Advertising expense 5,000.00
- Accounting and bookkeeping expense 500.00
- Owner's salary and benefits 8,000.00
- Dues and membership fees 167.00
- Licenses and permit fees 50.00
- Maintenance services 400.00
- Office supplies 300.00
- Sign 8.37(100/12months)
Total monthly Fixed Costs $16,840.61
Variable Costs per unit:
Ingredient | Cost | Small | Large | ||
Whole milk | $15 for 640 oz. | 0.02344 | per oz. | 0.05 | 0.07 |
Cream | $20 for 128 oz. | 0.15625 | per oz. | 0.31 | 0.47 |
Sugar | $10 for 30 cups | 0.33333 | per cup | 0.17 | 0.25 |
Premium Vanilla Ice Cream | $24 for 600 oz. | 0.04000 | per oz. | 0.24 | 0.36 |
Flavorings | 0.25 | 0.40 | |||
Flavored Specialty Straws | 0.75 | 0.75 | |||
Cups-8 ounces | $200 for 500 cups | 0.40000 | per cup | 0.40 | |
Cups-12 ounces | $250 for 500 cups | 0.50000 | per cup | 0.50 | |
TOTAL DIRECT MATERIAL COST PER UNIT | $2.17 | $2.80 |
Variable Cost Income Statement: using a 40% (small) and 60% (large) sales-mix in determining the break-even sales volume:
Small (40%) | Large (60%) | Weighted total | |
Sales after taking out the 10% owed to resort | $7*90%=6.3*40%= 2.520 | $10*90%=$9*60%= 5.400 | 7.920 per unit |
Variable cost | 2.17*40%=.868 | 2.80*60%=1.680 | 2.548 per unit |
Contribution margin | 1.652 | 3.720 | 5.372 per unit |
Total Fixed costs | 16,840.61 per month |
1) You will need to sell 3,135 milkshakes/month to break even = ($16,840.61/5.372) 1,254 (3,135*40%) will be small and 1,881 (3,135*60%) will be large.
Variable Cost Income Statement: using 40% (small) and 60% (large) sales-mix in determining the break-even sales volume (no salary allowance for owner):
Small (40%) | Large (60%) | Weighted total | |
Sales after taking out 10% owed to resort | $6.30*1,254milkshakes $7,900.20 | $9*1,881milkshakes $16,929.00 | $24,829.20 |
- Variable cost | $2.17*1,254milkshakes $2,721.18 | $2.80*1,881milkshakes $5,266.80 | $ 7,987.98 |
Contribution margin | $5,179.02 | $11,662.20 | $16,841.22 |
Total Fixed costs | $16,840.61 | ||
Net Income | 0.61 rounding error |
Note: The break even sales volume is 3,134.89 milkshakes. The Variable Cost Income Statement uses the breakeven quantity of 3,135 milkshakes.A small gain is shown due to rounding error since you cannot sell fractional milkshakes.
REQUIREMENTS OF THE SECOND PART OF THE CASE
The second part of this case is intended to demonstrate the importance of using a BUDGET process to plan, direct and control the organization..
- Using assumptions you made in the first part of the case regarding, sales price per unit, variable costs per unit and total fixed costs, as well as the information about sales volume presented below, prepare the following budgets for the first quarter:
- Sales budget
- Production budget
- Direct materials budget for JUST THE MILK - to save time I filled in the other raw material budgets necessary to make milk shakes
- Manufacturing Overhead budget
- Operating budget
- Using the information from the budgets you prepared above, prepare a projected Income Statement for the first month.
The Sales Budget must be prepared first as it affects all the other budgets. In order to prepare the sales budget an estimate of the expected number of units to be sold and the expected sales price needs to be determined. To prepare the sales budget we used the following assumptions. Statistics for tourism in Hawaii are available from thewww.hawaiitourismauthority.org and the Department of Business, Economic Development and Tourism of the State of Hawaii ( Hawaii.gov/debdt ).
- Number of visitors to the island from January 2007 to May 2007 were 125,000, 125,000, 150,000, 125,000 and 125,000, respectively. (For simplicity, we assume each visitor, on average, purchases one milk shake. (You can get more elaborate and research the average number of days visitors stay and the average number of couples, versus families with kids).
- The sales mix and the sales price will be consistent with the first part of the case at 40% small and 60% large with the sales price set at the competitors price of $10 for large and $7 for small (less the resort fee of 10%).
SALES BUDGET for 1stqtr | January | February | March | 1stqtr Total | April | May |
Large shakes expected to be sold: (visitors*.60) | ||||||
Expected sales price ($10*90%) | ||||||
Total sales ($) | ||||||
Small shakes expected to be sold: (visitors * .40) | ||||||
Expected sales price ($7*90%) | ||||||
Total sales ($) | ||||||
TOTAL SALES |
The next budget to be prepared is the Production budget, where the number of milk shakes needed to be produced (based on the sales budget) are determined. This will equal:
Number of milk shakes expected to be sold
+ safety stock (ending finished goods inventory) in case demand is higher than predicted
Total milk shakes needed
Less: Beginning finished goods inventory (which is zero at the start of business)
Milk shakes needed to be produced
To prepare the production budget we used the following assumptions:
- 10% of next months expected milk shake sales is desired to be left in ending inventory as a safety cushion.
- Remember, beginning inventory is last months ending inventory.
PRODUCTION BUDGET - 1st QTR | January | February | March | 1st Qtr total | April |
Large shakes (sales budget) | |||||
+ desired ending inventory | |||||
Total needed | |||||
Less: beginning inventory | |||||
Large shakes to produce |
PRODUCTION BUDGET - 1st QTR | January | February | March | 1st Qtr total | April |
Small shakes (sales budget) | |||||
+ desired ending inventory | |||||
Total needed | |||||
Less: beginning inventory | |||||
Small shakes to produce |
After the number of milk shakes needed to be produced is determined, we can plan for the amount of direct materials, direct labor and manufacturing overhead that will be needed.
A DIRECT MATERIALS budget will need to be produced for each ingredient used to make the milk shakes. The direct materials budget for whole milk was prepared using the following assumptions:
- 10% of next months expected milk needs are desired to be left in ending inventory as a safety cushion.
- Remember, beginning inventory is last months ending inventory.
- Cost of whole milk was determined to be $0.02344 per ounce
Milk Purchases Budget - 1st quarter | |||||
Large Milk Shake Production | |||||
Milk required per shake (ounces) | |||||
Ounces Needed for Large Milk Shake Production | |||||
Small Milk Shake Production | |||||
Milk required per shake (ounces) | |||||
Ounces needed for Small Milk Shake Production | |||||
Total Ounces Required for Production | |||||
Plus: Desired ending Inventory | |||||
Total Ounces Available | |||||
Less: Beginning Inventory | |||||
Total Ounces to be Purchased | |||||
Cost per Ounce | |||||
Total Cost of Milk to be Purchased |
DIRECT MATERIALS BUDGET - CREAM.
The direct materials budget for cream was prepared using the following assumptions:
- 10% of next months expected cream needs are desired to be left in ending inventory as a safety cushion.
- Remember, beginning inventory is last months ending inventory.
- Cost of cream was determined to be $0.15625 per ounce
Cream Purchases budget - 1st Quarter | |||||
January | February | March | Total | April | |
Large Milk Shake production | 82,500 | 76,500 | 88,500 | 247,500 | 75,000 |
Cream required per shake(ounces) | 3 ounces | 3 ounces | 3 ounces | 3 ounces | 3 ounces |
Ounces Needed for Large Milk Shake Production | 247,500 | 229,500 | 265,500 | 742,500 | 225,000 |
Small Milk Shake Production | 55,000 | 51,000 | 59,000 | 165,000 | 50,000 |
Cream required per shake(ounces) | 2 ounces | 2 ounces | 2 ounces | 2 ounces | 2 ounces |
Ounces Needed for Small Milk Shake Production | 110,000 | 102,000 | 118,000 | 330,000 | 100,000 |
Total Ounces Required for Production | 357,500 | 331,500 | 383,500 | 1,072,500 | 325,000 |
Plus: Desired Ending Inventory | 33,150 | 38,350 | 32,500 | 32,500 | 32,500 |
Total Ounces Available | 390,650 | 369,850 | 416,000 | 1,105,000 | 357,500 |
Less: Beginning Inventory | -0- | 33,150 | 38,350 | -0- | 32,500 |
Total Ounces to be Purchased | 390,650 | 336,700 | 377,650 | 1,105,000 | 325,000 |
Cost per Ounce | $0.15625 | $0.15625 | $0.15625 | $0.15625 | $0.15625 |
Total Cost of Cream to be Purchased | $61,039.06 | $52,609.38 | $59,007.81 | $172,656.25 | $50,781.25 |
DIRECT MATERIALS BUDGET - SUGAR.
The direct materials budget for sugar was prepared using the following assumptions:
- 10% of next months expected sugar needs are desired to be left in ending inventory as a safety cushion.
- Remember, beginning inventory is last months ending inventory.
- Cost of sugar was determined to be $0.33333 per cup.
Sugar Purchases Budget - 1st Quarter | |||||
January | February | March | Total | April | |
Large Milk Shake Production | 82,500 | 76,500 | 88,500 | 247,500 | 75,000 |
Sugar required per shake (in cups) | cup | cup | cup | cup | cup |
Cups Needed for Large Milk Shake Production | 61,875 | 57,375 | 66,375 | 185,625 | 56,250 |
Small Milk Shake Production | 55,000 | 51,000 | 59,000 | 165,000 | 50,000 |
Sugar required per shake (in cups) | cup | cup | cup | cup | cup |
Cups Needed for Small Milk Shake Production | 27,500 | 25,500 | 29,500 | 82,500 | 25,000 |
Total Cups Required for Production | 89,375 | 82,875 | 95,875 | 268,125 | 81,250 |
Plus: Desired Ending Inventory | 8,288 | 9,588 | 8,125 | 8,125 | 8,125 |
Total Cups Available | 97,663 | 92,463 | 104,000 | 276,250 | 89,375 |
Less: Beginning Inventory | -0- | 8,288 | 9,588 | -0- | 8,125 |
Total Cups to be Purchased | 97,663 | 84,175 | 94,412 | 276,250 | 81,250 |
Cost per Cup | $ 0.33333 | $ 0.33333 | $ 0.33333 | $ 0.33333 | $ 0.33333 |
Total Cost of Sugar to be Purchased | $32,554.01 | $28,058.05 | $31,470.35 | $92,082.41 | $27,083.06 |
DIRECT MATERIALS BUDGET - ICE CREAM.
The direct materials budget for ice cream was prepared using the following assumptions:
- 10% of next months expected ice cream needs are desired to be left in ending inventory as a safety cushion.
- Remember, beginning inventory is last months ending inventory.
- Cost of ice cream was determined to be $0.04 per ounce.
Ice Cream Purchases Budget - 1st Quarter | |||||
January | February | March | Total | April | |
Large Milk Shake Production | 82,500 | 76,500 | 88,500 | 247,500 | 75,000 |
Ice Cream Required per shake | 9 ounces | 9 ounces | 9 ounces | 9 ounces | 9 ounces |
Ounces needed for Large Milk Shake Production | 742,500 | 688,500 | 796,500 | 2,227,500 | 675,000 |
Small Milk Shake Production | 55,000 | 51,000 | 59,000 | 165,000 | 50,000 |
Ice Cream Required per shake | 6 ounces | 6 ounces | 6 ounces | 6 ounces | 6 ounces |
Ounces needed for Small Milk Shake Production | 330,000 | 306,000 | 354,000 | 990,000 | 300,000 |
Total Ounces Required for Production | 1,072,500 | 994,500 | 1,150,500 | 3,217,500 | 975,000 |
Plus: Desired Ending Inventory | 99,450 | 115,050 | 97,500 | 97,500 | 97,500 |
Total Ounces Available | 1,171,950 | 1,109,550 | 1,248,000 | 3,315,000 | 1,072,500 |
Less: Beginning | -0- | 99,450 | 115,050 | -0- | 97,500 |
Total Ounces to be Purchased | 1,171,950 | 1,010,100 | 1,132,950 | 3,315,000 | 975,000 |
Cost per ounce | $ 0.04 | $ 0.04 | $ 0.04 | $ 0.04 | $ 0.04 |
Total Cost of Ice Cream to be Purchased | $46,878.00 | $40,404.00 | $45,318.00 | $132,600.00 | $39,000.00 |
DIRECT MATERIALS BUDGET - FLAVORINGS.
The direct materials budget for flavorings was prepared using the following assumptions:
- 10% of next months expected flavoring needs are desired to be left in ending inventory as a safety cushion.
- Remember, beginning inventory is last months ending inventory.
- Cost of flavorings was $ 0.40 for a large shake and $ 0 .25 for a small shake.
Flavorings Purchases Budget - 1st Quarter | |||||
January | February | March | Total | April | |
Large Milk Shake Production | 82,500 | 76,500 | 88,500 | 247,500 | 75,000 |
Plus: Desired Ending Inventory | 7,650 | 8,850 | 7,500 | 7,500 | 7,500 |
Total Available | 90,150 | 85,350 | 96,000 | 255,000 | 82,500 |
Less: Beginning Inventory | -0- | 7,650 | 8,850 | -0- | 7,500 |
Total to be Purchased | 90,150 | 77,700 | 87,150 | 255,000 | 75,000 |
Cost per unit | $ 0.40 | $ 0.40 | $ 0.40 | $ 0.40 | $ 0.40 |
Total Cost of Flavorings to be Purchased for Large Milk Shakes | $36,060.00 | $31,080.00 | $34,860.00 | $102,000.00 | $30,000.00 |
Small Milk Shake Production | 55,000 | 51,000 | 59,000 | 165,000 | 50,000 |
Plus: Desired Ending Inventory | 5,100 | 5,900 | 5,000 | 5,000 | 5,000 |
Total Available | 60,100 | 56,900 | 64,000 | 170,000 | 55,000 |
Less: Beginning Inventory | -0- | 5,100 | 5,900 | -0- | 5,000 |
Total to be Purchase | 60,100 | 51,800 | 58,100 | 170,000 | 50,000 |
Cost per unit | $ 0.25 | $ 0.25 | $ 0.025 | $ 0.25 | $ 0.25 |
Total Cost of Flavorings to be Purchased for Small Milk Shakes | $15,025.00 | $12,950.00 | $14,525.00 | $42,500.00 | $12,500.00 |
Total Cost of Flavorings to be Purchased for ALL Milk Shakes | $51,085.00 | $44,030.00 | $49,385.00 | $144,500.00 | $42,500.00 |
DIRECT MATERIALS BUDGET - STRAWS.
The direct materials budget for straws was prepared using the following assumptions:
- 10% of next months expected straw needs are desired to be left in ending inventory as a safety cushion.
- Remember, beginning inventory is last months ending inventory.
- Cost per straw is $ 0.75.
Straws Purchases Budget - 1st Quarter | |||||
January | February | March | Total | April | |
Large Milk Shake Production | 82,500 | 76,500 | 88,500 | 247,500 | 75,000 |
Small milk shake Production | 55,000 | 51,000 | 59,000 | 165,000 | 50,000 |
Total straws Required for Production | 137,500 | 127,500 | 147,500 | 412,500 | 125,000 |
Plus: Desired Ending Inventory | 12,750 | 14,750 | 12,500 | 12,500 | 12,500 |
Total Available | 150,250 | 142,250 | 160,000 | 425,000 | 137,500 |
Less: Beginning Inventory | -0- | 12,750 | 14,750 | -0- | 12,500 |
Total Straws to be Purchased | 150,250 | 129,500 | 145,250 | 425,000 | 125,000 |
Cost per straw | $ 0.75 | $ 0.75 | $ 0.75 | $ 0.75 | $ 0.75 |
Total cost of straws to be Purchased | $112,687.50 | $97,125.00 | $108,937.50 | $318,750.00 | $93,750.00 |
DIRECT MATERIALS BUDGET -CUPS.
The direct materials budget for cups was prepared using the following assumptions:
- 10% of next months expected cup needs are desired to be left in ending inventory as a safety cushion.
- Remember, beginning inventory is last months ending inventory.
- Cost per cup is $ 0.50 for a large shake and $ 0.40 for a small shake.
Cups Purchases Budget - 1st Quarter | |||||
January | February | March | Total | April | |
Large Milk Shake Production | 82,500 | 76,500 | 88,500 | 247,500 | 75,000 |
Plus: Desired Ending Inventory | 7,650 | 8,850 | 7,500 | 7,500 | 7,500 |
Total Available | 90,150 | 85,350 | 96,000 | 255,000 | 82,500 |
Less: Beginning Inventory | -0- | 7,650 | 8,850 | -0- | 7,500 |
Total cups to be Purchased | 90,150 | 77,700 | 87,150 | 255,000 | 75,000 |
Cost per Cup | $ 0.50 | $ 0.50 | $ 0.50 | $ 0.50 | $ 0.50 |
Total Cost of Cups to be Purchased | $45,075.00 | $38,850.00 | $43,575.00 | $127,500.00 | $37,500.00 |
Cups Purchases Budget - 1st Quarter | |||||
January | February | March | Total | April | |
Small Milk Shake Production | 55,000 | 51,000 | 59,000 | 165,000 | 50,000 |
Plus: Desired Ending Inventory | 5,100 | 5,900 | 5,000 | 5,000 | 5,000 |
Total Available | 60,100 | 56,900 | 64,000 | 170,000 | 55,000 |
Less: Beginning Inventory | -0- | 5,100 | 5,900 | -0- | 5,000 |
Total cups to be Purchased | 60,100 | 51,800 | 58,100 | 170,000 | 50,000 |
Cost per Cup | $ 0.40 | $ 0.40 | $ 0.40 | $ 0.40 | $ 0.40 |
Total Cost of Cups to be Purchased | $24,040.00 | $20,720.00 | $23,240.00 | $68,000.00 | $20,000.00 |
MANUFACTURING OVERHEAD BUDGET
First, we need to determine whether each manufacturing overhead expense is variable or fixed. It has been determined that all the manufacturing overhead costs are fixed, although salary of part-time workers and utilities can be variable or mixed expenses as well.
Manufacturing Overhead Budget - 1st Quarter | ||||
January | February | March | Total | |
Fixed manufacturing overhead costs: | ||||
Salary of 2 part-time workers | ||||
Rent and utilities expense | ||||
Supplies for making milk shakes | ||||
Depreciation - milk shake maker | ||||
Depreciation - refrigerator/freezer | ||||
Depreciation - counter tops | ||||
TOTAL FIXED COSTS |
OPERATING BUDGET
First we need to determine whether each operating budget expense is variable or fixed. It has been determined that all the operating costs are fixed.
Operating Budget - 1st Quarter | ||||
January | February | March | Total | |
Fixed operating expenses: | ||||
Depreciation - tables and benches | ||||
Insurance expense | ||||
Interest expense | ||||
Advertising expense | ||||
Accounting and bookkeeping expense | ||||
Owner's salary expense | ||||
Dues and membership expense | ||||
Licenses and Permits expense | ||||
Maintenance expense | ||||
Office supplies expense | ||||
Depreciation - sign | ||||
TOTAL FIXED COSTS |
So what is the BUDGETED MANUFACTURING COST FOR ONE UNIT:
Direct Materials Variable Costs per unit:
Ingredient | Cost | Small | Large | ||
Whole milk | $15 for 640 oz. | 0.02344 | per oz. | 0.05 | 0.07 |
Cream | $20 for 128 oz. | 0.15625 | per oz. | 0.31 | 0.47 |
Sugar | $10 for 30 cups | 0.33333 | per cup | 0.17 | 0.25 |
Premium Vanilla Ice Cream | $24 for 600 oz. | 0.04000 | per oz. | 0.24 | 0.36 |
Flavorings | 0.25 | 0.40 | |||
Flavored Specialty Straws | 0.75 | 0.75 | |||
Cups-8 ounces | $200 for 500 cups | 0.40000 | per cup | 0.40 | |
Cups-12 ounces | $250 for 500 cups | 0.50000 | per cup | 0.50 | |
TOTAL DIRECT MATERIAL COST PER UNIT | $2.17 | $2.80 |
LARGE MILK SHAKES - per the PRODUCTION budget we expect to produce 1,580,000 in the first Year: (125,000+125,000+150,000+125,000+125,000+150,000+160,000+150,000+110,000+110,000
+110,000+140,000).
- Direct materials cost per milk shake: = 2.80
- Manufacturing overhead:
Fixed ($2,234.00 *12months * 60% per quarter)/ 1,580,000 =
milk shakes = 0.01
Cost of manufacturing each large milk shake = $2.81
SMALL MILK SHAKES - per the PRODUCTION budget we expect to produce 165,000 in the first quarter.
- Direct materials cost per milk shake: = 2.17
- Manufacturing overhead:
Fixed ($2,234.00 * 12 months * 40% per quarter)/ 1,580,000 =
milk shakes = 0.01
Cost of manufacturing each small milk shake = $2.18
PROJECTED INCOME STATEMENT - MONTH OF JANAURY
Large (60%) | Small (40%) | Total | |
Number of milk shakes expected to be sold | 75,000 | 50,000 | 125,000 |
Sales price per milk shake (less resort fee) | $9.00 | $6.30 | |
Cost of goods sold per milk shake | $2.81 | $2.18 | |
Sales | |||
Less: cost of goods sold | |||
Gross Profit | |||
Less: Operating expenses | |||
Operating Income | |||
Income tax expense (income tax rate = 35%) | |||
Net Income |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started