(3marks)c. The Ambrosia Bakery makes cakes for freezing and subsequent sale. The bakery, whichoperates five days a week, 52 weeks a year, can produce cakes at the rate of I16 cakesper day. The bakery sets up the cake-production operation and produces until apredetermined number have been produced. When not producing cakes, the bakery usesits personnel and facilities lor produciny other bakery tems Ihe selup cost lor aoduction run of cakes is 700 The cost of holdling frozen cakes in storage is 9 perCake per year. the annual demand lor Ihuzen cakes, which Is contant over time, is G000cakes.Determine the lollowing1Optimal production run quantityii. The maximum inventoryii. Total annual inventory costsiv. Optimal number of production runs per yearV. Optimal cyele tinie (time between run starts)

Answered: Image /qna-images/answer/046f6758-246e-4a9b-9fa0-f60753edbad6.jpg

c. The Ambrosia Bakery makes cakes for freezing and subsequent sale. The bakery, which operates five days a week, 52 weeks a year, can produce cakes at the rate of I16 cakes per day. The bakery sets up the cake-production operation and produces until a predetermined number have been produced. When not producing cakes, the bakery uses is personnel and facilities for poduciny other bakery tems The selup cost for a oduction run of cakes is e700 The cost of holding frozen cakes in storage is per cake per year. the annual demand for huzen cakes, whlch is constant over lime, is 6000 cakes. Determine the following 1Optimal production run quantity ii. The maximurm inventory iii. Total annual inventory costs

c. The Ambrosia Bakery makes cakes for freezing and subsequent sale. The bakery, which operates five days a week, 52 weeks a year, can produce cakes at the rate of I16 cakes per day. The bakery sets up the cake-production operation and produces until a predetermined number have been produced. When not producing cakes, the bakery uses is personnel and facilities for poduciny other bakery tems The selup cost for a oduction run of cakes is e700 The cost of holding frozen cakes in storage is per cake per year. the annual demand for huzen cakes, whlch is constant over lime, is 6000 cakes. Determine the following 1Optimal production run quantity ii. The maximurm inventory iii. Total annual inventory costs

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

A B 6 Variable Cells 7 8 9 10 11 12 Constraints 13 14 Cell Name $B$4 Acres allotted Soybean $C$4 Acres allotted Corn 15 16 C Cell Name $D$2 Workers Amt used $D$3 Fertilizer Amt used 17 $D$4 Acres allotted Amt used 2500 3100 166.67 1166.67 D Final Value 166.6666667 1166.666667 Final Value 1500 5000 1333.333333 E Reduced Cost 0 0 Shadow Price 633.3333333 616.6666667 0 F 2500 3100 G Objective Allowable Allowable Coefficient Increase Decrease 1500 5000 1500 H 3700 1900 950 1850 Constraint Allowable Allowable R.H. Side Increase Decrease 500 1000 1E+30 166.6666667 250 3500 Kinkaid grows soybeans and corn on his land about 12 miles outside of Hartington in northeast Nebraska. He needs to figure out how many acres of the land to allot to each crop to maximize his profit. After solving the problem using Excel, the following sensitivity report is generated. What is the profit margin of Corn?
b. Question 4 Fortis Utility Company uses 2,000 units per year which it stores at $0.50 per unit per annum. The cost to place an order is $100. Calculate: If the company decides to make the items on its own machine with a potential capacity of 4,000 units per year, calculate: i. the batch order quantity (BOQ) the annual ordering cost the annual carrying cost ii. the economic order quantity (EOQ) the number of orders. iii.
php?attempt=104149&cmid%330865 aline Services v OS Ticket system My Dispense Academic Calendar N My courses 3) v Q b) Calculate the weighted moving average for periods 7 through 10 using weights of 0.6, 0.3, and 0.1. n Lo S : Cha Weighted moving Period Actual average 1 64 2 84 3 91 4 97 115 6. 135 7. 137 8. 144 6. 153 10 171 beriods 7 through 10. Use 5.
1. Explain (2) possible risks of working at a fuel supply plant 2. Explain The important of training for those working at a fuel supply plant.
The units of Manganese Plus available for sale during the year were as follows: Mar. 1 June 16 Nov. 28 Inventory Purchase Purchase 23 units @ $29 32 units @ $30 42 units @ $36 97 units $667 960 1,512 $3,139 There are 14 units of the product in the physical inventory at November 30. The periodic inventory system is used. a. Determine the inventory cost by the FIFO method. $ b. Determine the inventory cost by the LIFO method. $ c. Determine the inventory cost by the weighted average cost methods. Round intermediate calculations and final answer to two decimal places.