Problem 8-12Alan Industries is expanding its product line to include three new products: A, B, and C. These are to be produced on the same production equipment, and the objective is to meet thedemands for the three products using overtime where necessary. The demand forecast for the next four months, in hours required to make each product is:PRODUCTABCAPRIL800Regular timeOvertime600700Objective valueMAY600700500Because the products deteriorate rapidly, there is a high loss in quality and, consequently, a high carrying cost when a product is made and carried in inventory to meet future demand.Each hour's production carried into future months costs $3 per production hour for A, $4 for Model B, and $5 for Model C.Production can take place either during regular working hours or during overtime. Regular time is paid at $4 when working on A, $5 for B, and $6 for C. The overtime premium is 50percent of the regular time cost per hour.The number of production hours available for regular time and overtime isAPRIL1,500700JUNE800900700MAY1,300650Calculate the objective value using Excel Solver.JULY1,2001,100850JUNE1.800900JULY2,0001,000

Find the Given details below: Given details: Product April May June July A 800 600 800 1200…

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

What do you understand by capacity planning? Explain the decision tree modeling for capacity expansion
Belmand College is a registered private higher education institution. It specialises in IT diplomas and professional courses. The college has a total enrolment of about 150 students. They have four admin employees, a librarian, and three full time lecturers. Part time lecturers are hired every semester. They are currently using Microsoft Excel to handle the administration of the college. The current system being used has many of challenges. It is error prone, monotonous and it is not easy to use and update. They are also using Google Classroom to deliver online lectures. Management have made a decision to adopt an integrated computerised system. Draw activity diagrams for an admin, showing the process which they will follow when admitting a student.
A manager must decide which type of machine to buy, A, B, or C. Machine costs (per individual machine) are as follows: Machine Cost $50,000 A B $40,000 C $70,000 Product forecasts and processing times on the machines are as follows: PROCCESSING TIME PER UNIT (minutes) Annual Product Demand 1 2 3 4 18,000 25,000 15,000 9,000 A 1 5 4 5 A B C B Click here for the Excel Data File 6531 Total processing time in minutes per machine: a. Assume that only purchasing costs are being considered. Compute the total processing time required for each machine type to meet demand, how many of each machine type would be needed, and the resulting total purchasing cost for each machine type. The machines will operate 8 hours a day, 220 days a year. (Enter total processing times as whole numbers. Round up machine quantities to the next higher whole number. Compute total purchasing costs using these rounded machine quantities. Enter the resulting total purchasing cost as a whole number.) C 2 1 2 6
Hand written solutions are strictly prohibited
Deforrest Marine Motors manufactures engines for the speedboat racing circuit. As part of their annual planning cycle, they forecasted demand for the next four quarters. The number of available days of production and the anticipated demand are given below. Employees Production Rate Production Cost Backorder Cost Overtime Cost Overtime Limit Demand Q1 2,400 6,019,000 They also estimated many of the costs required to conduct operations planning. Some of these key figures are listed below. 30 70 units/employee/quarter Q2 2,200 $1,000/unit $200/unit/quarter $1,500/unit <= 25% of Reg. Production Q3 1,700 Q4 1,800 Hire Cost Fire Cost Subcontracting Cost Subcontracting Limit Inventory Cost Initial Inventory $1,200/employee $800/employee $1,800/unit 400 units maximum $100/unit/quarter 280 units Deforrest Marine Motors wishes to maintain the current number of employees for the entire year to follow a level strategy balanced with inventory and backorders as needed. What is the total cost of this…
9
Use the following for the next 2 questions: A company forecasts that it will ship 120,000 boxes of product in June. The product has a monthly turnover of 3. The company plans to use its facility to ship 80,000 boxes and the balance of the 40,000 boxes will ship from a rented facility. Space may be rented for a charge of $7 per box per month with an in-and-out handling charge of $0.45 per box shipped. 1. What is the rented (fixed) storage cost for June? - $280,000 - $180,000 - $42,500 - $250,000 - $93,333 - $153,333 - $173,333 2. What is the rented variable cost for June? - $33,333 - $43,333 - $6,000 - $38,000 - $18,000 - $28,000 - $23,333
The manager of Roth Corporation, wants to determine whether or not the type of work schedule for her employees has any effect on their productivity. She has selected 15 production employees at random and then randomly assigned 5 employees to each of the 3 proposed work schedules. The following table shows the units of production (per week) under each of the work schedules. Work Schedule (Treatments) Schedule 1 50 60 70 40 45 Compute MSTR MSTR- 95 94.68 128.166 3.8856 Schedule 2 60 65 65 58 57 Schedule 3 75 75 55 40 55
The company Customer First A-to-Z uses a make to stock strategy. Product A is thecompany’s main product. The forecast for Product A, the accepted customer ordersand the master production schedule is shown below. The company presently has150 units on hand and a fixed master production schedule quantity of 80 units isused. Product A Forecast Customer Orders MPS Week Quantity Week Quantity Week Quantity 1 60 1 45 1 2 60 2 66 2 80 3 60 3 55 3 4 60 4 65 4 5 60 5 40 5 6 60 6 22 6 7 60 7 10 7 8 60 8 5 8 9 60 9 4 9 10 60 10 2 10 Required:A. Help the master production scheduler to fill in the master schedule calculationtable shown below, by using the forecast, the customer orders and the plannedproduction of product A. 1 2 3 4 5 6 7 8 9 10 Ft Dt EIt-1 Pt EIt ATPt B. The marketing department has accepted an…
Chalimbana university farm is about to hire workers for its production of cabbage in a space of 5 months. as a student of farm management, you decide to increase the labour by 2 units at the first output,1 unit in the second and third output, 16 units in the fourth output and 20 units in the fifth output at each production level. The farm then realizes an output of 10,25, 65,30, and 30 in that period. The farm workers got a wage of k40 per month.a. Calculate the following at different level of output.i. marginal product, (MP) ii marginal revenue product (MRP) iii marginal resource cost (MRC)
Q46 Mixing Company manufactured 2,500 units of its only product during 2022. The inputs for this production are as follows: 550 pounds of Material A at a cost of $2.50 per pound 400 pounds of Material H at a cost of $3.75 per pound 700 direct labor hours at $60 per hour The firm manufactured 3,920 units of the same product in 2021 with the following inputs: 700 pounds of Material A at a cost of $2.20 per pound 560 pounds of Material H at a cost of $3.50 per pound 600 direct labor hours at $58 per hour The partial operational productivity of Material A in 2021 is: Multiple Choice 5.60 units per pound. 0.44 units per pound. 4.67 units per pound. 5.18 units per pound. 0.51 units per pound.
A Company currently has 230 units of a product on-hand that it orders every three weeks when the salesperson visits the premises. Average demand for the product is 20 units per day with a standard deviation of 5 units. Lead time for the product to arrive is seven days. Management has a goal of 95 percent probability of not stocking out for this product. The salesperson is due to come in late this afternoon when 210 units are left in stock. How many units should be ordered?

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