Alan Industries is expanding its product line to include three new products: A, B, and C. These are to be produced on the sameproduction equipment, and the objective is to meet the demands for the three products using overtime where necessary. The demandforecast for the next four months, in hours required to make each product is:PRODUCTABCAPRIL770570670Regular timeOvertimeMAY570670470Because the products deteriorate rapidly, there is a high loss in quality and, consequently, a high carrying cost when a product is madeand carried in inventory to meet future demand. Each hour's production carried into future months costs $3 per production hour for A,$4 for B, and $5 for C.Objective valueProduction can take place either during regular working hours or during overtime. Regular time is paid at $4 when working on A, $5for B, and $6 for C. The overtime premium is 50 percent of the regular time cost per hour.The number of production hours available for regular time and overtime isAPRIL1,470670JUNE770870670MAY1,300620JULY1,1701,070820JUNE1,770870JULY1,950990Calculate the objective value using Excel Solver. (Do not round intermediate calculations.)

Find the given details below: Given…

Answered: Alan Industries is expanding its…

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

City Sod is a small business that sells and lays sod (rolled strips of grass). The owner has devised a forecasting procedure based on demand history from previous years plus projection of demand in recent weeks. The forecast for the next six weeks, in labor hours of sod laying, is 850 870 950 910 970 870 CmTently, City Sod has a staff of sod layers consisting of five crew chiefs and 15 laborers. A crew chief lays sod along with the laborers, but also directs the crew. The owner has decided on the following staffing policies: A two-week backlog will be accmnulated before adding staff. Plans are based on a 40 hour work week; overtime is used only to absorb weather or other delays and employee absence or resignations. The ideal crew size is one crew chief and four laborers. Devise a hiring plan for the first three weeks. In your answer, assmne a current backlog of 1,480 labor hours of sod-laying orders. Does City Sod follow a chase-demand or level-capacity strategy of…
In exponential smoothing method, which one of the following statements is true? O a. Alpha is between 0 and 1, and high value of alpha is used for stable demand O b. Alpha is between 0 and 1, and high value of alpha is used for unstable demand O c. Alpha is greater than 1, and high value of alpha is used for stable demand O d. Alpha is greater than one, and high value of alpha is used for unstable demand O e. Alpha is negative, and high value of alpha is used for stable demand US PAGE acer F2 F3 F4 F5 F6 F7 Coc) F8 F9 F10 F11 图, 2$
Kelsie Corporation is using a predetermined overhead rate that was based on estimated total fixed manufacturing overhead of $510,000 and 30,000 machine-hours for the period. The company incurred actual total fixed manufacturing overhead of $517,000 and 27,000 total machine-hours during the period. The amount of manufacturing overhead that would have been applied to all jobs during the period is closest to: Select one: O a. $459,000 O b. $574,444 O c. $17 Od. $19.15
Plz solve!!
Prescribed fire is an important tool for foresters. A recent article describes how decision analysis is used to decide when, where and what to burn. In one example, a number of areas in the Tahoe National Forest in California had been logged and were being prepared for replanting. Preparation included prescribed burning, and two possible treatments were available: burning the slash as it lay on the ground, or “yarding of and merchantable material” (YUM) prior to burning. The latter treatment involves using heavy equipment to pile the slash. YUM reduces the difficulty of controlling the burn but costs an additional $100 per acre. In deciding between the two treatments two uncertainties were considered critical. The first was how the fire would behave under each scenario. For example, the buyer could be fully successful, problems could arise which could be controlled eventually, or the fire could escape entailing considerable losses. Second if problems developed, they could result in…
Design capacity is the ability of the company to produce the quantity of goods and services within a particular period of time when the company have best condition to produce and when the company have unlimited resources. These resource's includes- Men, Machinery, Material etc. It shows the maximum capacity of the company to produce. Effective capacity refers to the ability of the company to produce maximum quantity within a particular period of time to achieve in current production condition and current resources. It shows the real outcome capacity of the firm when the company produce within their own current condition of their production. In design capacity it is assume that the company will produce in best and ideal condition to produce goods and services while in Effective capacity it is assume that company will produce in current operating conditions. In design capacity it is assume that the company have unlimited resource's. It means these resource's include:- Men,…
A bicycle component manufacturer produces hubs for bike wheels. Two processes are possible for manufacturing, and the parameters of each process are as follows: Process 1 Production rate Daily production time Process 2 35 parts/hour 4 hours/day 20% 15 parts/hour 7 hours/day 9% Percent parts rejected Assume that the daily demand for hubs allows all defect-free hubs to be sold. Select the process that maximizes profit per day if each part is made from $4 worth of material and can be sold for $30. Both processes are fully automated, and variable overhead cost is charged at the rate of $40 per hour.
A company evaluate its hiring cost is RM150 per worker and layoff cost is RM200 per worker. Currently the company has 20 workers and based on forecast demand, the actual workers required to meet January demand is 25 workers. Calculate the hiring cost or layoff cost for that month. * O RM750 O RM350 O RM250 O RM1,000
Create a Crow’s Foot notation ERD to support the following business operations: Create a Crowsfoot notation ERD to support the following business operations: - A friend of yours has opened Marshfield Electronics and Repairs (MER) to repair smartphones, laptops, tablets, and MP3 players. She wants you to create a database to help her run her business. When a customer brings a device to MER for repair, data must be recorded about the customer, the device, and the repair (also referred to as repair request). Completing each repair request can involve multiple services (e.g. glass replacement, battery replacement, cleaning. Some services require parts. The customer’s name, address, and a contact phone number must be recorded. For the device to be repaired, the type of device, model, and serial number are recorded (or verified if the device is already in the system). Each repair request is given a reference number, which is recorded in the system along with the date of the request, and a…
1. Foxie Owl’s Besty Bagel shop makes fresh bagels. She has to buy raw materials fresh every day for selling on that day. She wants to know exactly how much should she spend on raw materials. Foxie did some analysis over the past month and came back with the following numbers: Daily demand was equally likely to be 200, 225, 250, 275, or 300 bagels. What should be the number of bagels on hand to satisfy a Fill Rate requirement of 96%, rounded to next integer value? Group of answer choices 300 275 286 263 2. Suppose that instead of a discrete demand distribution, Foxie’s shop determines that the daily demand for bagels is normally distributed, with a mean of 250 and a standard deviation of 35. Foxie still wants a Fill Rate of 98%. What is the appropriate level of on-hand inventory for Foxie’s shop? Group of answer choices 263 274 257 270
A company produces three products A,B, and C. The products are processed through three machines as follows Product Annual demand Standard Time on m/c 1 Standard Time on m/c 2 Standard Time on m/c 3 A 600 5 -- 8 B 350 8 2 -- C 1000 1 12 10 If there are 250 working days per year and the company plans to work one seven hours shift per day, then compute the number of machines required.
c5 need urgent in 15 minutes

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS