Phionias Finicky Feline Gourmet Cat Dinners

NOTE: There is a spreadsheet template provided for this assignment. You have to use it in order to complete the assignment.

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:

Nov	Dec	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug
4,300	4,600	5,000	5,500	6,100	6,800	7,000	7,200	7,400	7,500

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 months 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:

Item	$ per pound
Lamb	$15.00
Rice	1.20
Salmon	24.00
Vitamins	45.00

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 time if there is not enough demand for them to work full time. It 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.

1. Prepare the following budgets for the period January through June, by month and in total for the period, using the spreadsheet template provided:

• Sales budget in dollars
• Production budget in units
• Direct materials purchases budget in pounds
• Direct materials purchases 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.

Assumptions lbs./case Cost/lb. Total S/hr Lamb Ingr. Prep Cook/Can Rice Salmon Vitamins Cost/8 hr. day JAN-JUN 50.00 Jan Feb May Jun July Dec 4300 4500 5000 Mar 5500 Apr 6100 6800 7 000 7200 37,600 7500 4300 4500 5000 5500 5100 5800 7 000 7200 37,600 Sales Budget Production Budget Nov Projected Sales in Cases Add: Desired Ending Inventory Amount Needed Less: Beginning inventory # Cases to Produce Ingredient Inventory (