Mr. Meadows Cookie Company makes a variety of chocolate chip cookies in the plant in Albion, Michigan. Based on orders received and forecasts of buying habits, it is estimated that the demand for the next four months is 850,1,260, 510, and 980, expressed in thousands of cookies. During a 46-day period when there were 120 workers, the company produced 1.7 million cookies. Assume that the number of workdays over the four months are respectively 26, 24, 20, and 16. There are currently 100 workers employed, and there is no starting inventory of cookies.a. What is the minimum constant workforce required to meet demand over the next four months?b. Assume that cI = 10 cents per cookie per month, cH = $100, and cF = $200. Evaluate the cost of the plan derived in part (a).c. Formulate as a linear program. Be sure to define all variables and include the required constraints.d. Solve for the optimal solution.

Mr. Meadows Cookie Company makes a variety of chocolate chip cookies in the plant in Albion, Michigan. Based on orders received and forecasts of buying habits, it is estimated that the demand for the next four months is 850,1,260, 510, and 980, expressed in thousands of cookies. During a 46-day period when there were 120 workers, the company produced 1.7 million cookies. Assume that the number of workdays over the four months are respectively 26, 24, 20, and 16. There are currently 100 workers employed, and there is no starting inventory of cookies.a. What is the minimum constant workforce required to meet demand over the next four months?b. Assume that cI = 10 cents per cookie per month, cH = $100, and cF = $200. Evaluate the cost of the plan derived in part (a).c. Formulate as a linear program. Be sure to define all variables and include the required constraints.d. Solve for the optimal solution.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter10: Introduction To Simulation Modeling

Section: Chapter Questions

Problem 41P: At the beginning of each week, a machine is in one of four conditions: 1 = excellent; 2 = good; 3 =...

See similar textbooks

Similar questions

At the beginning of each week, a machine is in one of four conditions: 1 = excellent; 2 = good; 3 = average; 4 = bad. The weekly revenue earned by a machine in state 1, 2, 3, or 4 is 100, 90, 50, or 10, respectively. After observing the condition of the machine at the beginning of the week, the company has the option, for a cost of 200, of instantaneously replacing the machine with an excellent machine. The quality of the machine deteriorates over time, as shown in the file P10 41.xlsx. Four maintenance policies are under consideration: Policy 1: Never replace a machine. Policy 2: Immediately replace a bad machine. Policy 3: Immediately replace a bad or average machine. Policy 4: Immediately replace a bad, average, or good machine. Simulate each of these policies for 50 weeks (using at least 250 iterations each) to determine the policy that maximizes expected weekly profit. Assume that the machine at the beginning of week 1 is excellent.
Harold Grey owns a small farm in the Salinas Valley that grows apricots. The apricots are dried on the premises and sold to a number of large supermarket chains.Based on past experience and committed contracts, he estimates that sales over thenext five years in thousands of packages will be as follows:Forecasted DemandYear (thousands of packages)1 3002 1203 2004 1105 135Assume that each worker stays on the job for at least one year, and that Greycurrently has three workers on the payroll. He estimates that he will have 20,000packages on hand at the end of the current year. Assume that, on the average, eachworker is paid $25,000 per year and is responsible for producing 30,000 packages. Inventory costs have been estimated to be 4 cents per package per year, andshortages are not allowed.Based on the effort of interviewing and training new workers, Farmer Greyestimates that it costs $500 for each worker hired. Severance pay amounts to$1,000 per worker.a. Assuming that shortages are not…
In past 4 weeks, AOC (Arab oil company) started producing and distributing national engine oil to substitute French Total and Esso brands. Production reported to be in thousands: 2, 4, 3, 5 TG Thousand Gallons). AOC production will be calculated after 5 more weeks.
What is the average number of tennis balls does Skousen maintain?
difference between order statistics and quantile?
The check book balance of Ccc Company on December 31,2020 was P4,000,000. Data about certain cash items follow. • A customer amounting to P200,000 dated January 2,2021 was not included in the December 31,2020 checkbook balance. • Another customer check for P500,000 deposited on December 22,2020 was included in its checkbook balance but returned by the bank for insufficiency of fund. The check was deposited on January 5, 2021 and cleared two days. + A P400,000 check payable to supplier dated and recorded on December 30,2020 was mailed on January 16,2021. * A petty cash fund of P50,000 with the following summary on December 31,2020: Coins and Currencies 5,000 Petty cash vouchers 43,000 Return value of 20 cases of soft drinks 2,000 50,000 • A check of P43,000 was drawn on December 31,2020 payable to petty cash. 3. What is the "cash" balance on December 31,2020?
c. Compute and tabulate the daily demand for each month in the table below (round off to the nearest whole number). MONTH PRODUCTION DAYS DEMAND FORECAST DEMAND PER DAY JAN 2022 16 150 ? FEB 2022 16 150 ? MAR 2022 23 250 ? APR 2022 21 250 ? MAY 2022 22 400 ? JUN 2022 22 500 ? JUL 2022 21 600 ? AUG 2022 20 750 ? SEP 2022 20 450 ? OCT 2022 20 250 ? NOV 2022 16 150 ? DEC 2022 16 150 ? TOTAL ? ? d. Assuming that MPQ Limited had adopted a level strategy for the year ended 31 December 2022, compute the average daily demand for the year (round off to the nearest whole number). e. Prepare a graph showing the monthly forecasts and average daily forecast (in units per day) for MPQ Limited.
Colleen Company has gathered the following data pertaining to activities it performed for two of its major customers. Jerry, Inc. Kate Co. Number of orders 6 30 Units per order 1,000 420 Sales returns: Number of returns 4 5 Total units returned 50 140 Number of sales calls 13 5 Colleen sells its products at $290 per unit. The firm’s gross margin ratio is 20%. Both Jerry and Kate pay their accounts promptly and no accounts receivable is over 30 days. After using business analytics software to carefully analyze the operating data for the past 30 months, the firm has determined the following activity costs: Activity Cost Driver and Rate Sales calls $ 800 per visit Order processing 180 per order Deliveries 410 per order Sales returns 270 per return and $3 per unit returned Sales salary 107,000 per month Required: 1. Using customers as the cost objects, classify the activity costs…
Scenario: You are the supervisor of the Sales Department of Khemlani Furniture. It is customary to check the attendance register semi-annually to determine attendance and punctuality of supervisees. Your checks revealed the following for Joanalee Smith: late for 160 days for more than 30 minutes each morning absent for 10 days without proper documentation. You met with Ms Smith and presented your findings mentioned above. At that meeting, she explained that her parents, who live with her, are sick and she has a special needs daughter who she takes to the day care each morning. Together you explored some options and arrived at an amicable solution. Task: With the aid of a computer, prepare a report to the management of your organisation outlining the following: the results of your attendance and punctuality checks your findings from the meeting with your supervisee decisions taken during the meeting. The following skills should be demonstrated: proofread,…
A method of estimating future demand usedfor decision making in order to set reasonable targets and control orlimit uncertainties or risks.
Adele Weiss manages the campus flower shop. Flowers must be ordered three days in advance from her supplier in Mexico. Although Valentine’s Day is fast approaching, sales are almost entirely last-minute, impulse purchases. Advance sales are so small that Weiss has no way to estimate the probability of low (25 dozen), medium (60 dozen), or high (130 dozen) demand for red roses on the big day. She buys roses for $15 per dozen and sells them for $40 per dozen. Construct a payoff table. Which decision is indicated by each of the following decision criteria?a. Maximinb. Maximaxc. Laplaced. Minimax regret
The controller's staff at McNichols Lubricants is responsible for preparing quarterly performance reports. One report evaluates quarter- to-quarter improvement in partial productivity of the two main inputs in the production process: base chemical and labor. Management at McNichols is particularly interested in the results because there have been numerous efficiency improvement programs instituted at the company recently. Data for the last two quarters follow: Barrels input Labor-hours Barrels of output Required: a. Compute the partial productivity measures for labor for quarter 1 and quarter 2. b. Compute the partial productivity measures for material for quarter 1 and quarter 2. c-1. Have the efficiency improvement programs resulted in greater labor productivity? c-2. Have the efficiency improvement programs resulted in greater material productivity? Req A Complete this question by entering your answers in the tabs below. Quarter 2 42,000 8,400 28,056 Quarter Req B Quarter 1 Quarter…