Reference no: EM132184168
Just Baked cupcakes sold at retail stores for prices ranging from about $2.30 each for simpler cupcakes by the dozen up to about $3.50 for the fanciest cupcakes sold individually. Most of the cupcakes were sold in 2-packs priced at $5.50. An approximate overall average selling price was $2.75 per cupcake. Franchisees were charged $1.25 per cupcake. Company-owned stores were also “charged” the same transfer price of $1.25 per cupcake. Total variable costs per cupcake out of the Livonia bakery were about $0.50, representing $0.25 in direct material and $0.25 in variable labor. Cupcakes not sold by the end of the day were discarded. Just Baked credited the stores $0.75 for each unsold/discarded cupcake.
Research indicated that customers were generally willing to purchase cupcakes from those available, even if they had to substitute a second choice for a most-preferred flavor. For the purposes of this exercise, understocking costs are confined to the immediate lost sales profit.
In practice, Just Baked did not permit franchisees to make their own cupcake-ordering decisions. Instead, cupcakes were baked and delivered to all stores based on centralized decisions.
When Pam Turkin began the business in her kitchen, she used a particular brand of packaged cake mix in two flavors (vanilla and chocolate) as the basic material on which all the Just Baked (JB) flavor recipes were variations. Even though the business had grown dramatically, this recipe structure remained. The cake mixes were bought in pallet-load quantities for JB. Due to the strong weekly cupcake sales pattern, inventory planning for cake mix was done on a weekly basis. Cake mix orders were placed with a grocery store chain distribution warehouse. Cake mixes were delivered 3 days after order placement.
Occasionally, the grocery warehouse had insufficient inventory to fill JB’s orders, resulting in insufficient raw material to support JB’s baking operations. When this happened, JB employees would drive to grocery stores in the Livonia vicinity and buy boxes of cake mix off the store shelves until they had enough to support the baking operations. This typically required visits to about 20 retail stores, and in Turkin’s words “it takes all day.” Coping with this situation required an average of 15 hours of employee overtime and cost $20 per hour inclusive of mileage expenses. Prices paid in the stores were also higher, amounting to an extra cost per pallet of $300.
Although Just Baked had grown via reinvestment of retained earnings, 12% is a reasonable approximation for the relevant annual cost of capital i which should be considered to apply to inventory holding of cake mix. Assume 360 days per year. Physical holding costs are negligible at the margin, since the Livonia facility has sufficient warehouse space to accommodate all reasonable inventory required. Obsolescence and shelf life considerations also do not apply to cake mixes, which are typically coded for sale up to eighteen months after packing. The value of a pallet of cake mix at JB’s cost including delivery charges is $1000.
Real butter and fresh eggs are also important ingredients in Just Baked cupcakes. These are managed according to a continuous review system and ordered whenever inventory levels reach a reorder point. Annual demand D for eggs is 600,000. The cost of placing an egg order S, including delivery charges, is $40. Lead time for eggs is 1 day. Holding costs for eggs are dominated by their limited shelf life and the requirement that they be held in cold storage and handled with care. These costs total $0.02 per egg per day. Financial holding costs are negligible.
Daily demand for eggs averages about 1600, but there are significant variations from day to day. The standard deviation of daily egg demand is 400. Daily demand for eggs is approximately normally distributed.
What is the underage for cupcakes for a franchise? A. $1.00 B. $2.00 C. $1.50 D. $2.25
What is the underage for a company-owned store for cupcakes? A. $2.75 B. $2.25 C. $.50 D. $1.50
What is the overage for cupcakes for a franchise? A. $.50 B. $1.00 C. $.25 D. $.75
What is the overage for cupcakes for a company-owned store? A. $.50 B. $1.00 C. $.75 D. $.25
What is the profit-maximizing service-level for cupcakes for a franchise? A. .85 B. .75 C. .65 D. .95
What is the profit-maximizing service-level for cupcakes for a company-owned store? A. .92 B. .72 C. .62 D. .82
What is the stockout cost for cake mix? A. $300 B. $450 C. $900 D. $600
What is the annual holding cost of a pallet of cake mix? A. $110 B. $120 C. $90 D. $130
What is the cost of overstocking one pallet of cake mix for one week? A. $2.30 B. $3.30 C. $1.30 D. $4.30
What is the profit-maximizing service level for pallets of cake mix? A. .696 B. .796 C. .996 D. .896
What is the target stock level for cake mix? A. 4 B. 5 C. 2 D. 3