Question

Phionia Phelps has developed a gourmet cat food. Not only is this food eagerly eaten by the most finicky felines, but it is specially formulated to prevent the many health problems of aging cats. Phionia has been making the food on her kitchen range and selling it at $250 per case only to close acquaintances who are also cat lovers. One of her wealthy acquaintances has now offered to invest in her business if Phionia will begin selling the product through her website. However, the investor wants Phionia to produce a budget for the first six months of operation. Based on her experience to date, Phionia predicts the following sales in cases:

Each case of Finicky Feline Gourmet Cat Dinner requires 5 pounds of prime lamb meat, 10 pounds of short grain Chinese rice, 2 pounds of wild caught Alaskan salmon, and 1 pound of secret vitamins and supplements. Phionia plans to maintain end-of-month inventories equal to 10 percent of the next month's projected sales, to meet expected sales growth. All the ingredients inventories are to be maintained at 5 percent of the production needs for the next month, but not to exceed 1,000 pounds of any one ingredient. January will begin with all inventories at the projected levels. Phionia has the following price quotes good for the following year:
The production process requires direct labor at two skill levels: (1) ingredient preparation, $18 per hour, and (2) cooking and canning, $24 per hour. Two workers are willing to work part days if there is not enough demand for them to work full time. lt takes one hour to process one batch. Because of preparation and cleanup time, only six batches can be produced per day. Each batch produces enough food to fill 100 cases. Manufacturing overhead is $6,000 fixed per month plus $15 per case.
Item $ per pound
Lamb 15
Rice 1,20
Saimon 24
Viamlns 45
1. Prepare the following budgets for the period. January through June:________.
a. Sales budget in dollars.
b. Production budget in units.
c. Direct materials purchases budget in pounds.
d. Direct materials purchases budget in dollars.
e. Direct manufacturing labor budget in dollars.
2. Comment on the viability of this business and the advisability of the investor making a $50,000 investment to get it started.

Answer 1

Step-by-step explanation:

a.

Sales budget = $ 250 per case * 100 cases per batch * 6 batches per day * 20 days a month * 6 months

= $ 18,000,000

b. Production budget in units = 100 cases per batch * 6 batches per day * 20 days a month * 6 months

= 72,000 cases

Production budget including 10 percent inventories

= 72000 + 100*6*20*10%

= 73200 cases

c. Direct materials purchases budget in pounds including 5% inventories

Lamb = 5 pounds per case * (73200 cases + 100*6*20*5% cases )

= 369,000 pounds

Rice Lamb = 10 pounds per case * (73200 cases + 100*6*20*5% cases )

= 738,000 pounds

Salmon = 2 pounds per case * (73200 cases + 100*6*20*5% cases )

= 147,600 pounds

Vitamins = 1 pound per case * (73200 cases + 100*6*20*5% cases )

= 73,800 pounds

d. Direct materials purchases budget in dollars = 369000*15 + 738000*1.2 + 147600*24 + 73800*45

= $ 1,328,400

e. Manufacturing labor budget in dollars = 1 hours per batch * 6 batches per day * 20 days per month * 6 months * ($ 18 per hour for ingredient preparation + $ 24 per hour for cooking and canning ) * 2 workers

= $ 60,480

2. The business requires an investment of $ 1,328,400 + 60,480

= $ 1,388,880 over six months.

This translates to monthly investment of $ 231,480

Therefore $ 50,000 investment is too small to begin with.