Question

In: Accounting

Mama Angie’s Food Supplements, Inc.    Mama Angie’s Food Supplements, Inc. (MAFS) manufactures a single product,...

Mama Angie’s Food Supplements, Inc.

   Mama Angie’s Food Supplements, Inc. (MAFS) manufactures a single product, Endless Energy (EE), which is an all-natural, healthy, vitamin infused dietary supplement. Endless Energy is sold only in one gallon containers.

   This year, 2018, MAFS has prospered, with projected pretax earnings of over $1.1 million on sales of $6.84 million. Management is now in the process of planning next year's activity. The marketing department has been exploring several avenues for 2019. 2018's healthy sales resulted from a modest advertising and promotional expenditure of $188,000. Marketing management now believes that a concerted digital media campaign in 2019 (that would increase selling and administrative expenses by $125,000) could substantially boost unit sales by as much as 17 percent.

   The production department has also proposed a change for 2019. It has suggested that capacity should be boosted from the current 750,000 gallons to 1.1 million gallons. The changes made for this expansion would also reduce variable manufacturing overhead to $1.95 per gallon. The cost of the expansion would be $500,000, consisting mainly of equipment to be purchased in the first quarter of 2019 and to be paid for in March. This increase to plant and equipment would be depreciated over a ten-year period, using the straight line method with no salvage value. A full year's depreciation would be expensed in the first year.

   MAFS has the following policies/practices: Ending finished goods inventory generally equals one month's sales. Raw materials are purchased and delivered on a justintime basis, so no inventory should exist. Payments on account of purchases of raw material are generally paid in the month following that in which they are incurred. All other expenditures are paid as incurred. Accounts receivable are usually collected 50% in the month of sale, 50% in the month following. All sales are on credit.

   The statement of cost of goods manufactured and sold for 2018 and the 2018 income statement (both prepared in October 2018 and reflecting best available estimates at the time) are attached, along with some additional data.

Requirements

1. Mama Angie is concerned that the expansion of production capacity may require the company to seek external sources of financing. Prepare a cash budget for the first quarter of 2019 (i.e., schedule the cash inflows and outflows for the quarter). What is the amount of financing that Mama Angie will need to arrange for the quarter? (You may find it useful to start by preparing a production schedule/budget for the first quarter).

2. Mama Angie needs to know what income will be generated for next year. Prepare a statement of budgeted cost of goods manufactured and cost of goods sold for the year 2019. Please prepare a budgeted income statement for 2019.

3. Assume that the marking department has an alternative marketing plan to reduce the price per gallon of Endless Energy by $1. They expect that sales would increase by 20 percent over the 2018 level, even without additional levels of advertising expenditures. Prepare a budgeted income statement for 2019 under this scenario.

4. Should Mama Angie accept the new marketing proposal? Please explain.

Mama Angie’s Food Supplements, Inc.

Data Table                        2018

Sales (gallons)                    570,000

Selling Price                        $12.00

Fixed Selling & Admin Expenses        $986,000.00

(includes depreciation of $36,000)

Commissions (as % of Sales Dollars)        5.00%

Shipping (as % of Sales Dollars)           3.00%

Variable Manufacturing Costs (per unit):

   Direct Materials                $4.00

   Direct Labor                    $1.00

   Variable Overhead                $2.00

   Fixed Manufacturing Costs (total,   $180,000.00

   includes depreciation of $60,000)

Total Production (gallons)            600,000

December's Production (gallons)        51,000

Inventory Summary: (gallons)

Finished Goods Inventory, Jan 1        21,000

Finished Goods Inventory, Dec 31        51,000

Budgeted cash balance, Dec 31        $50,000

Mama Angie Food Supplements, Inc.

Statement of Cost of Goods Manufactured & Sold

   for the Year Ended December 31, 2018

  

Cost of Goods Manufactured:

   Direct Materials                    $2,400,000.00

   Direct Labor                        600,000.00

   Variable Overhead                       1,200,000.00

   Fixed Manufacturing Cost                180,000.00

                                   $4,380,000.00

Add:

Finished Goods Inventory Jan 1               198,000.00

Total Available for Sale                   $4,578,000.00

Less:

Finished Goods Inventory Dec 31               (372,300.00)

Cost of Goods Sold                        $4,205,700.00

Income Statement

for the Year Ended December 31, 2018

   Sales                                   $6,840,000.00

   less: Cost of Goods Sold                       (4,205,700.00)

   Gross Margin                                $2,634,300.00

       Fixed Selling & Admin Expense            (986,000.00)

       Variable Selling & Admin Expense            (547,200.00)

   Operating Income                            $1,101,100.00

Solutions

Expert Solution

PROPOSAL 1
Working Note 1
It is given that by increasing sales promotion expenses the sales can be increased by 17%
So the new sales will be 570000+ 570000*17% 666900 Gallons
Inventory at the year end is not given but it is given that inventory is kept at one months sale
Average sales during the year will be 666900/12 55575 Gallons
So the production requirement will be Sales + Closing invetory - Opening inventory ie
Working Note 2
Increase in Manufacturing Fixed Overhead -New Equipment to be purchases $ 500000
Depreciation - On Straight Line Basis for 10 years without salvage value = 500000/10 ie $ 50000 per annum
Current Fixed Manufacturing Overheads 180000
Less Current Depreciation included (60000)
Fixed Manufacturing Overhead without depreciation 120000
Depreciation     Existing 60000
Add : Depreciation of new Equip 50000
Total Deprecation 110000
Budgeted Fixed Overhead for 2019 230000
Note : Since the equipment is used for manufacturing process Depreciation will be considered in Manufacting overheads
Working Note 3
Sales in Gallons 666900
Selling Price $12
Sales Value in Dollars 8002800
PRODUCTION BUDGET IN UNITS
Particulars Gallons
Sales 666900
add : Closing inventory 55575
Less : Opeing Inventory (51000)
Production 671475
COST OF GOODS MANURACTURED (PRODUCTION BUDGET) IN DOLLARS
Particulars Gallons Dollars/ Gallon Dollars Per Annum Dollars for First Quarter
Direct Material 671475 4 2685900 671475
Direct Labor 671475 1 671475 167869
Variable Overhead 671475 1.95 1309377 327345
Fixed Manfacturing Overhead 230000 57500
671475 7.292531 4896752 1224189
Add : Finished Inventory on 1st Jan 51000 372300
Total Avaiable for Sales 722475 5269052
Less Closing Inventory 55575 405283
Cost of Goods Sold 4863769
COST OF GOODS SALES
Particulars Gallons Dollars/ Gallon Dollars Per Annum Dollars for First Quarter
Cost of Goods Sold 4863769 1215942
Add: Fixed Selling Expenses (Existing) 986000 246500
Add: Additional Fixed Expenses 125000 31250
Add: Variable Selling expenses
Commission 5% of $8002800 400140 100035
Shipping 3% of $ 8002800 240084 60021
Cost of Goods Sales 6614993
STATEMENT OF BUDGETED INCOME
Particulars Dollars Per Annum
Sales    80,02,800.00
Less Cost of Sales    66,14,993.00
Income    13,87,807.00
Working Note for Cash Budget
1) Sales Collection
      Monthly sale - 8002800/12 for 2019 666900
Collection for January
- Of December 282000 Average sale for month in 2018
-of January 50% of 666900 333450 570000/12 ie 47500
Collection for February Sales for Month of December in dollars
   -of January 50% of 666900 333450 47500*12 564000
   -of February 50% of 666900 333450 Collection in December 282000
Collection in January 282000
Collection of March
   - of February 50% of 666900 333450
   - Of March 50% of 666900 333450
Total Sales Collection 1949250
2) Raw Material Payment
Monthly Raw Material for 2018 200000 2400000/12
Monthly Raw Material for 2019 223825 2685900/12
Payment for Raw Material
In the month of January for December 200000 As payment is made one month credit
In the month of February for January 223825
In the month of March for February 223825
Total Raw Material Payment 647650
3) Fixed Cost Expneses in cash
Total Mfg Fixed cost per annum Without Dep 120000
Quarterly fixed Cost without depreciation 30000
Total Selling Fixed Cost p.a. without depreciation 950000 986000-36000
Quarterly fixed Cost without depreciation 237500
CASH BUDGET
Particulars Dollars Dollars
Cash Inflow
Sales Collection 1949250
Cash Outflow
Manufacturing Expenses
Raw Materail 647650
Labor 167869
Variable Overhead 327345
Fixed Manfacturing Overhead 30000
Fixed Selling Expenses Wthout Depreciation 237500
Additional Fixed Expenses 31250
Commission 5% 100035
Shipping 3% 60021 (1601670)
Cost of Equipment (500000)
Net Cash flow -152420
Add : Opening Balance 50000
Short fall to be borrowed -102420
PROPOSAL 2
Reduce price by $1 and increase in sales by 20%
Calculation of sales
Existing sales 570000
Increased sales 20% of 570000 114000
Total Expected sales 684000
Selling price (Reduce by $1) 11
Sales in Dollars 7524000
Calculation of Production
Sales in Gallons 684000
Add: Closing inventory 684000/12 57000
741000
Less Opening Inventory 51000
Production 690000
Note : Since existing capacity is 750000 gallons and production as budgeted is 690000 gallons
there is no need to increase capacity
GALLONS RATE DOLLARS
Cost of Goods Sold
Direct Material 690000 4 2760000
Direct Labor 690000 1 690000
Variable Overhead 690000 2 1380000
Fixed Manufacturing Overhead 180000
690000 7.26087 5010000
Add : Opening Inventory 51000 372300
5382300
Less : Closing Inventory 57000 (413870) 57000*7.26087
Cost of Goods Sold 5796170
Income Statement
Sales 7524000
Less Cost of Goods Sold (5796170)
Gross Margin 1727830
Less Fixed Selling Expenses (986000)
Less : Variable Selling Expenses
     Commission 5% on Sales (376200)
     Shipping 3% on sales (225720)
Operating Income 139910
Proposal 1 is better than proposal 2

Related Solutions

Altec Manufacturing Inc. (Altec) is a company that manufactures and sells a single product, which they...
Altec Manufacturing Inc. (Altec) is a company that manufactures and sells a single product, which they call an Altec. For planning and control purposes they utilize a monthly master budget, which is usually developed at least six months in advance of the budget year. Their fiscal year end is December 31. As per the request of the CEO of Altec John Hofmann, you as new controller will be preparing the next budget (January to December 2022). Prior to the task,...
Altec Manufacturing Inc. (Altec) is a company that manufactures and sells a single product, which they...
Altec Manufacturing Inc. (Altec) is a company that manufactures and sells a single product, which they call an Altec. For planning and control purposes they utilize a monthly master budget, which is usually developed at least six months in advance of the budget year. Their fiscal year end is December 31. As per the request of the CEO of Altec John Hofmann, you as new controller will be preparing the next budget (January to December 2022). Prior to the task,...
Information: Altec Manufacturing Inc. (Altec) is a company that manufactures and sells a single product, which...
Information: Altec Manufacturing Inc. (Altec) is a company that manufactures and sells a single product, which they call an Altec. For planning and control purposes they utilize a monthly master budget, which is usually developed at least six months in advance of the budget year. Their fiscal year end is December 31. As per the request of the CEO of Altec John Hofmann, you as new controller will be preparing the next budget (January to December 2022). Prior to the...
Kings, Inc. manufactures and sells a single product. A partially completed schedule of the company’s total...
Kings, Inc. manufactures and sells a single product. A partially completed schedule of the company’s total and per unit costs over the relevant range of 30,000 to 50,000 units produced and sold annually is given below. Complete the schedule of the company’s total and unit costs above. Units Produced and Sold 30,000 40,000 50,000 Total Costs: Variable costs $180,000 ? ? Fixed Costs $300,000 ? ? Total Costs $480,000 ? ? Cost per unit: Variable Cost ? $4.50 ? Fixed...
Arnold Inc. is considering a proposal to manufacture​ high-end protein bars used as food supplements by...
Arnold Inc. is considering a proposal to manufacture​ high-end protein bars used as food supplements by body builders. The project requires use of an existing​ warehouse, which the firm acquired three years ago for $2 million and which it currently rents out for $101,000. Rental rates are not expected to change going forward. In addition to using the​ warehouse, the project requires an upfront investment into machines and other equipment of $1.5 million. This investment can be fully depreciated​ straight-line...
Arnold Inc. is considering a proposal to manufacture​ high-end protein bars used as food supplements by...
Arnold Inc. is considering a proposal to manufacture​ high-end protein bars used as food supplements by body builders. The project requires use of an existing​ warehouse, which the firm acquired three years ago for $ 2 million and which it currently rents out for $ 102,000. Rental rates are not expected to change going forward. In addition to using the​ warehouse, the project requires an upfront investment into machines and other equipment of $ 1.2 million. This investment can be...
Arnold Inc. is considering a proposal to manufacture high-end protein bars used as food supplements by...
Arnold Inc. is considering a proposal to manufacture high-end protein bars used as food supplements by body builders. The project requires use of an existing warehouse, which the firm acquired three years ago for $1 million and which it currently rents out for $120,000. Rental rates are not expected to change going forward. In addition to using the warehouse, the project requires an up-front investment into machines and other equipment of $1.4m. This investment can be fully depreciated straight-line over...
Arnold Inc. is considering a proposal to manufacture high-end protein bars used as food supplements by...
Arnold Inc. is considering a proposal to manufacture high-end protein bars used as food supplements by body builders. The project requires use of an existing warehouse, which the firm acquired three years ago for $2 million and which it currently rents out for $129,000. Rental rates are not expected to change going forward. In addition to using the warehouse, the project requires an up-front investment into machines and other equipment of $1.4 million. This investment can be fully depreciated straight-line...
Arnold Inc. is considering a proposal to manufacture high-end protein bars used as food supplements by...
Arnold Inc. is considering a proposal to manufacture high-end protein bars used as food supplements by body builders. The project requires use of an existing warehouse, which the firm acquired three years ago for $2 million and which it currently rents out for $129,000. Rental rates are not expected to change going forward. In addition to using the warehouse, the project requires an up-front investment into machines and other equipment of $1.4 million. This investment can be fully depreciated straight-line...
Arnold Inc. is considering a proposal to manufacture​ high-end protein bars used as food supplements by...
Arnold Inc. is considering a proposal to manufacture​ high-end protein bars used as food supplements by body builders. The project requires use of an existing​ warehouse, which the firm acquired three years ago for $2 million and which it currently rents out for $124,000. Rental rates are not expected to change going forward. In addition to using the​ warehouse, the project requires an upfront investment into machines and other equipment of $1.3 million. This investment can be fully depreciated​ straight-line...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT