Business math?

Business math?

A supermarket bakery must decide how many birthday cakes to prepare for the upcoming weekend. Cakes cost $66 each to make, and they sell for $94 each. Unsold cakes are sold at $33 on Monday, and typically all the remaining cakes are sold at that price on Monday. Demand is normally distributed with the mean of 144 and standard deviation of 28.8. Determine the followings:Cost of Shortage (Cs): Cost of excess? What is the optimal service level? What is the corresponding Z value? Top of Form What is the optimal number of birthday cakes to make for the weekend? A large bakery makes cakes for freezing and subsequent sale. The bakery can produce cakes at the rate of 1875 cakes per day. The bakery sets up the cake-production operation and produces until a predetermined number (Q) have been produced. When not producing cakes, the bakery uses its personnel and facilities for producing other bakery items. The setup cost for a production run of cakes is $100. The cost of holding frozen cakes in storage is $9 per cake per year. The annual demand for frozen cakes, which is constant over time, is 54600 cakes. Assume 364 days a year and 52 weeks a year. What is the “daily” demand rate? How many frozen cakes to produce in a production cycle? (keep two decimal places) How many cakes are in the freezers when the bakery stops the production in a given production cycle? (keep two decimal places) How many “days” is the production cycle? How many “days” in each production cycle the bakery produces cakes to freeze? How many “days” in each production cycle the bakery is not producing cakes and can use its personnel and facilities for producing “other” bakery items? How much is the total annual inventory related costs? 3) A bakery buys sugar from a big distributor to use in baking cakes. Typically, they use 3675 bags of sugar in a year. The price of sugar is typically $14 per bag. The cost to the bakery for placing an order is $25, and the annual carrying cost is $20 per bag. The distributor has offered the bakery the following volume discount schedule: Order Size Discount rate on the original price 1–449 0 percent 450–799 5 percent more than 800 10 percent We are trying to find how many bags of sugar should the store order, whenever they place a new order of sugar.Assume 364 days a year and 52 weeks a year. IMPORTANT: Note, the discounts off of original price are reported. You need to calculate the actual prices. Keep two decimal places in your calculations.If we ignore the discounts, how many bags of sugar should we order? Fill in the blanks: Order Quantity Unit Price to Pay Total Annual Inventory Related Cost Quantity from EOQ model Enough to get 5 percent discount Enough to get 10 percent discount Based on this quantity discount information, how may bags of sugar should the store order? How often (in “days”) should the bakery order? A bakery buys sugar from a big distributor to use in baking cakes. Typically, they use 30 pounds of sugar in a day. But depending on the day, they may use a little bit less or more. It is estimated that the standard deviation of demand for sugar is 3 lbs per day. It takes 4 days from the time the bakery orders sugar until the distributor delivers the sugar. The manager wants to have a service level of 0.8. Determine each of the following, assuming that demand is distributed normally. Z value for the intended service level The safety stock that will provide the intended service level: The ROP that will provide the intended service level :

Business math?

5) The follow table lists the demand of cakes during the past few months. Use the data to forecast the demand for May, based on the following methods: Month Demand Jan 100 Feb 96 Mar 90 Apr 96 Naive approach.Simple moving average with span of 2.Weighted moving average with weights of 0.5, 0.38, and 0.12.Simple exponential smoothing with smoothing factor of 0.15.Keep two decimal places in your calculations. Month Forecasts: Naïve Forecasts: Simple Moving Forecasts: Weighted Moving Forecasts: Exponential Jan Feb Mar Apr May 6) Consider the following data. We want to monitor the forecasts. Period Demand Forecasts 52 — 62 58 59 62 53 66 58 68 Also, we want to monitor the forecasts using tracking signals with control limits of ±4 MADs.Answer the following related questions:Below fill in the blanks (cumulative errors, MADs, and tracking signals of periods 3, 4 and 5).Keep two decimal places in your calculations. Period Cumulate Errors MADs Tracking Signals — — — — — — Based on tracking signals of period 4 and 5, are the forecasts biased? (Yes/No) 7) Consider the following data. We want to monitor the forecasts. Period Demand Forecasts 52 — 62 67 59 67 53 64 58 62 We want to calculate the UCL and the LCL for the appropriate control chart to monitor the magnitute of errors.Answer the following related questions:Below fill in the blanks (errors of periods 2 through 5).Keep two decimal places in your calculations. Period Errors — Calculate the overall MSE to determine if the errors of the forecasts are in control. overall MSE: UCL for the control chart? LCL for control Chart? Based on your control chart, are the forecasts in control? (Yes/No)