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…
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
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…
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.
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.
Jefferson Company's demand for its only product exceeds its manufacturing capacity. The company provided the following information for the machine whose limited capacity is prohibiting the company from producing and selling additional units. 4,900 minutes 7,000 minutes 3.8 units per minute 4.0 units per minute 15,827 units 18,620 units Actual run time this week Machine time available per week Actual run rate this week Ideal run rate Defect-free output this week Total output this week (including defects) Required: 1. Compute the utilization rate. (Round your answer to 2 decimal places.) 2. Compute the efficiency rate. (Round your answer to 2 decimal places.) 3. Compute the quality rate. (Round your answer to 2 decimal places.) 4. Compute the overall equipment effectiveness (OEE). (Do not round intermediate calculations. Round your final answer to 3 decimal places.) Utilization rate Efficiency rate Quality rate Overall equipment effectiveness
c4 need urgent in 15 minutes
A plant operation has fixed cost of $2,000,000 per year, and its output capacity is 100,000 electrical appliances per year. The variable cost is $70 per unit, and the product sells for $120 per unit. a) What is the annual break even volume of this product? b) Compare annual profit when the plant is operating at 90% capacity with the plant operation at 100% capacity. Assume that the first 90% of capacity output is sold at $120 per unit and that the remaining 10% of production is sold at $100 per unit. Show handwritten solutions
The following information relates to the performance of a manager in 2020. Benchmark weight Return on the benchmark Actual returnActual Weight Equity Bonds Cash 7.28% 0.6 0.5 6.00% 3.20% 0.90% 3.60% 0.90% 0.2 0.3 0.2 0.2 Details of investments in different sectors of the equity market are as follows: Sector Beginning of month weights S&P 500 Sector return Basic material 1.96 6.30 6.9 Business services 5.80 7.10 7.0 Capital goods 1.91 8.80 4.1 Consumer cyclical 8.47 12.50 8.8 Consumer non-cyclical 40.37 19.40 10.0 Credit sensitive 24.01 20.80 5.0 Energy Technology 13.53 13.20 2.6 3.95 11.90 0.6
A local semiconductor firm, Superchip, is planning its workforce and productionlevels over the next year. The firm makes a variety of microprocessors and usessales dollars as its aggregate production measure. Based on orders received and sales forecasts provided by the marketing department, the estimate of dollarsales for the next year by month is as follows:Production Predicted DemandMonth Days (in $10,000)January 22 340February 16 380March 21 220April 19 100May 23 490June 20 625July 24 375August 12 310September 19 175October 22 145November 20 120December 16 165Inventory holding costs are based on a 25 percent annual interest charge. It is anticipatedthat there will be 675 workers on the payroll at the end of the current year and inventorieswill amount to $120,000. The firm would like to have at least $100,000 of inventory at theend of December next year. It is estimated that each worker accounts for an average of$60,000 of production per year (assume that one year consists of 250…

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