Question

In: Statistics and Probability

The Pat-A-Cake Pastry Shop makes chocolate cake in three sizes – Small, Medium, and Large. For...

The Pat-A-Cake Pastry Shop makes chocolate cake in three sizes – Small, Medium, and Large. For each size, the number of cakes made is an integer (i.e. the shop does not bake only half of a cake). The shop has the following amounts of the three main ingredients on hand – 400 ounces of cake flour, 550 ounces of caster sugar, and 150 ounces of cocoa powder. The table below provides details on the amount of each ingredient required for each cake size as well as the profit contributions. The shop wants to make the appropriate amount of each cake size in order to maximize profit. Cake Small Medium Large Available Plain flour (Ounce) 8 16 21 400 Caster sugar (Ounce) 18 22 25 550 Cocoa powder (Ounce) 3 5 11 150 Profit/Unit $18 $25 $32

a. Develop a spreadsheet model and find the optimal solution using Excel Solver. What is the optimal total profit? Enter your answer without a dollar sign.

b. Based on your answer for a., what quantity of large cakes should be produced to maximize profit contribution? Remember that the number of cakes made should be an integer.

c. Based on your answer for a., what quantity of medium cakes should be produced to maximize profit contribution? Remember that the number of cakes should be an integer.

d. Based on your answer for a., what quantity of small cakes should be produced to maximize profit contribution? Remember that the number of cakes should be an integer.

Solutions

Expert Solution

orchestra answered 10 months ago
Next > < Previous

Related Solutions

A Cake & Pastry shop makes 3 types of cakes which require three significant ingredients, given...
A Cake & Pastry shop makes 3 types of cakes which require three significant ingredients, given the combination of other ingredients vary. The data for the amount of these ingredients needed to make the cakes are provided in the table below: Develop and solve a linear programming model to maximize the profit. What is the optimal solution for this problem? Cake Small Medium Large Available Plain flour (Ounce) 8 16 21 400 Caster sugar (Ounce) 18 22 25 550 Cocoa...
A beverage can manufacturer makes three sizes of soft drink cans—Small, Medium and Large. Production is...
A beverage can manufacturer makes three sizes of soft drink cans—Small, Medium and Large. Production is limited by machine availability, with a combined maximum of 105 production hours per day, and the daily supply of metal, no more than 200 kg per day. The following table provides the details of the input needed to manufacture one batch of 100 cans for each size. ​                                                                                Cans Large Medium Small Maximum Metal (kg)/batch 9 6 5 200 Machines’ Time (hr)/batch 4.4 4.2...
Lovejoy's Cake Shop makes three types of cakes: White, Chocolate, and, Swirl on one assembly line...
Lovejoy's Cake Shop makes three types of cakes: White, Chocolate, and, Swirl on one assembly line that has a limit of 400 labour-hours per week. Lovejoy can sell all the cakes it can make under current operating capacity. Manufacturing information per cake for each product is as follows:                                          White     Chocolate        Swirl Selling price                       $16            $10               $20 Variable costs                      10                5                 18 Labour-hours per cake         .4               .2                  .4 Required: Determine the total weekly contribution margin when all labour-hours are allotted...
A department store sells sport shirts in three sizes (small, medium, and large), three patterns (plaid,...
A department store sells sport shirts in three sizes (small, medium, and large), three patterns (plaid, print, and stripe), and two sleeve lengths (long and short). The accompanying tables give the proportions of shirts sold in the various category combinations. Short-sleeved Pattern Size Pl Pr St S 0.04 0.02 0.05 M 0.08 0.05 0.12 L 0.03 0.07 0.08 Long-sleeved Pattern Size Pl Pr St S 0.03 0.02 0.03 M 0.06 0.11 0.07 L 0.04 0.02 0.08 (a) What is the...
A department store sells sport shirts in three sizes (small, medium, and large), three patterns (plaid,...
A department store sells sport shirts in three sizes (small, medium, and large), three patterns (plaid, print, and stripe), and two sleeve lengths (long and short). The accompanying tables give the proportions of shirts sold in the various category combinations. Short-sleeved Pattern Size Pl Pr St S 0.04 0.02 0.05 M 0.09 0.05 0.12 L 0.03 0.07 0.08 Long-sleeved Pattern Size Pl Pr St S 0.03 0.02 0.03 M 0.08 0.08 0.07 L 0.04 0.02 0.08 (a) What is the...
The Stone Company produces three sizes of window fans: small, medium and large. The operations manager...
The Stone Company produces three sizes of window fans: small, medium and large. The operations manager has formulated the following LP model for fan production: Maximize Profit Z Z = 6×1 + 8×2 + 5×3             (profit) Subject to                                 3×1 + 4×2 + 5×3 ≤ 160 hours (Labor)                                 1×1 + 2×2 + 3×3 ≤ 100 pounds (Metal)                                 2×1 + 2×2 + 2×3 ≤ 110 pounds (Plastic)                                 ×3≥ 18 (Large Fan)                                 ×1,...
Performance Gloves, Inc. produces three sizes of sports gloves: small, medium, and large. A glove pattern...
Performance Gloves, Inc. produces three sizes of sports gloves: small, medium, and large. A glove pattern is first stenciled onto leather in the Pattern Department. The stenciled patterns are then sent to the Cut and Sew Department, where the glove is cut and sewed together. Performance Gloves uses the multiple production department factory overhead rate method of allocating factory overhead costs. Its factory overhead costs were budgeted as follows: 1 Pattern Department overhead $266,730.00 2 Cut and Sew Department overhead...
Kimbrell Inc. manufactures three sizes of utility tables—small (S), medium (M), and large (L). The income...
Kimbrell Inc. manufactures three sizes of utility tables—small (S), medium (M), and large (L). The income statement has consistently indicated a net loss for the M size, and management is considering three proposals: (1) continue Size M, (2) discontinue Size M and reduce total output accordingly, or (3) discontinue Size M and conduct an advertising campaign to expand the sales of Size S so that the entire plant capacity can continue to be used. If Proposal 2 is selected and...
Kimbrell Inc. manufactures three sizes of utility tables—small (S), medium (M), and large (L). The income...
Kimbrell Inc. manufactures three sizes of utility tables—small (S), medium (M), and large (L). The income statement has consistently indicated a net loss for the M size, and management is considering three proposals: (1) continue Size M, (2) discontinue Size M and reduce total output accordingly, or (3) discontinue Size M and conduct an advertising campaign to expand the sales of Size S so that the entire plant capacity can continue to be used. If Proposal 2 is selected and...
Mickey Company manufactures three different sizes of stuffed teddy bears (large, small and medium d corresponding...
Mickey Company manufactures three different sizes of stuffed teddy bears (large, small and medium d corresponding costs for the month of January 2004 are given below: large medium small projected unit sales 3,000 5,000 4,000 $ $ $ price per unit 40 30 20 variable cost per unit --direct material 12 10 8 --direct labour 8 5 3 --support costs 5 3 2 fixed cost per unit 2 2 2 total unit cost 27 20 15 It takes 20, 15...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT