Currently, ACME Corp. produces ladders for theme parks. Six flags (world's best theme parks) have decided...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Currently, ACME Corp. produces ladders for theme parks. Six flags (world's best theme parks) have decided to give some forecasts to ACME about the need for ladders. The demand of the ladders for the next 12 months are as follows: 6, 12, 4, 8, 15, 25, 20, 5, 10, 20, 5, 12. ACME has 4 ladders in their inventory and for future purposes, the company wants to have 8 ladders on their inventory after 12 months. As their factory is located at an urban area, the holding cost per item is calculated as $1. The setup cost for the ladder is $40 per production. With the information above, a) Construct the mathematical model of the problem in order to minimize total cost. b) Solve the problem using the Wagner-Whitin algorithm in MS Excel. c) Assuming a maximum order size of 20 per month, modify the mathematical model that you developed in Part (a) and update the solution that is obtained in Part (b). Currently, ACME Corp. produces ladders for theme parks. Six flags (world's best theme parks) have decided to give some forecasts to ACME about the need for ladders. The demand of the ladders for the next 12 months are as follows: 6, 12, 4, 8, 15, 25, 20, 5, 10, 20, 5, 12. ACME has 4 ladders in their inventory and for future purposes, the company wants to have 8 ladders on their inventory after 12 months. As their factory is located at an urban area, the holding cost per item is calculated as $1. The setup cost for the ladder is $40 per production. With the information above, a) Construct the mathematical model of the problem in order to minimize total cost. b) Solve the problem using the Wagner-Whitin algorithm in MS Excel. c) Assuming a maximum order size of 20 per month, modify the mathematical model that you developed in Part (a) and update the solution that is obtained in Part (b). Currently, ACME Corp. produces ladders for theme parks. Six flags (world's best theme parks) have decided to give some forecasts to ACME about the need for ladders. The demand of the ladders for the next 12 months are as follows: 6, 12, 4, 8, 15, 25, 20, 5, 10, 20, 5, 12. ACME has 4 ladders in their inventory and for future purposes, the company wants to have 8 ladders on their inventory after 12 months. As their factory is located at an urban area, the holding cost per item is calculated as $1. The setup cost for the ladder is $40 per production. With the information above, a) Construct the mathematical model of the problem in order to minimize total cost. b) Solve the problem using the Wagner-Whitin algorithm in MS Excel. c) Assuming a maximum order size of 20 per month, modify the mathematical model that you developed in Part (a) and update the solution that is obtained in Part (b). Currently, ACME Corp. produces ladders for theme parks. Six flags (world's best theme parks) have decided to give some forecasts to ACME about the need for ladders. The demand of the ladders for the next 12 months are as follows: 6, 12, 4, 8, 15, 25, 20, 5, 10, 20, 5, 12. ACME has 4 ladders in their inventory and for future purposes, the company wants to have 8 ladders on their inventory after 12 months. As their factory is located at an urban area, the holding cost per item is calculated as $1. The setup cost for the ladder is $40 per production. With the information above, a) Construct the mathematical model of the problem in order to minimize total cost. b) Solve the problem using the Wagner-Whitin algorithm in MS Excel. c) Assuming a maximum order size of 20 per month, modify the mathematical model that you developed in Part (a) and update the solution that is obtained in Part (b).
Expert Answer:
Related Book For
Auditing The Art And Science Of Assurance Engagements
ISBN: 9780136692089
15th Canadian Edition
Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Chris E. Hogan, Joanne C. Jones
Posted Date:
Students also viewed these general management questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
When not cooking for Cody and Lucky, Don works part-time as a logistics expert. Don needs to optimize the shipment of plastic plates from the Plants in Miami, St. Louis, and Cleveland to the...
-
Can the sum of the torques on an object be zero while the net force on the object is non-zero? Explain.
-
Consider the following inventory policy for the certain product. If the demand during a period exceeds the number of items available, this unsatisfied demand is backlogged; i.e., it is filled when...
-
For approximately 20 months, Robert E. McDonald perpetrated a scheme to solicit millions of dollars purportedly for a \($100\) million purchase by the RAI Entities and certain other related corporate...
-
Hiatt Textile Corporation is planning to expand its current plant facilities and is in the process of obtaining a loan at City Bank. The bank has requested audited financial statements. Hiatt has...
-
he accounts from the Adjusted Trial Balance are listed in alphabetical order. What is the total longminusterm liabilities? Baker Service Company Adjusted Trial Balance September 30, 2025 Balance...
-
The G. Saussy Manufacturing company is putting out four new electronic components. Each of Saussy's four plants has the capacity to add one more product to its current line of electronic parts. The...
-
The point (-3, 1) is on the transformed graph of f(x) original point on the graph of y f(x). - [2(x + 1)] 5. Find the
-
What is the difference between PPE as per Ind AS 16 and owner occupied property as defined in Ind AS 16?
-
Fairfield Companys payroll costs for the most recent month are summarized here: Item Description Total Cost Hourly labor wages 850 hours @ $27 per hour 170 hours for Job 101 = $ 4,590 330 hours for...
-
Hilltop School District receives a donation of ten computers from Computer Hut, a local computer firm.. The cost of Computer Hut of each computer is $2,500. The retail value of each computer is...
-
I. True/False/Uncertain - Briefly explain. No credit without an explanation (8 marks each). 1. At the 10th decile the (cumulative) lift would never be one. 2. With 4 categories of Y and 5 Xs, the...
-
A block of mass m = 5.4 kg slides on a rough surface and moves toward a spring with a spring constant k, as shown in the figure below. When the block is d = 13.6m away from the spring, it has a...
-
Claxton Corporation has three shareholders: Smith with 300 shares, Wesson with 300 shares, and Luger Corporation with 400 shares. None of the shareholders are related. Claxton has available E&P...
-
The May 2014 revenue and cost information for Houston Outfitters, Inc. follow: Sales Revenue (at standard).............. $ 540,000 Cost of Goods Sold (at standard) ..........341,000 Direct Materials...
-
Access CPA Canadas CAS 450, Evaluation of misstatements identified during the audit, to answer the following questions: a. What are the three types of misstatements that can be identified by an...
-
You are the audit senior in charge of the accounts receivable confirmations. One of the responses is from a company that has no operations in Canada, but you note the response is from a mailing...
-
Apex is a private company that manufactures pharmaceutical drugs. It is now December 15, 2020, and you are planning to attend the December 31 inventory count. Apexs year-end is December 31, 2020....
-
SpeedBurn Ltd manufactures DVD burners and is considering expanding production. A distributor has asked the company to produce a special order of 3000 DVD burners. The burners will be sold using a...
-
A to Z Pty Ltd has provided the following planned perunit cost and sales data for the year ended 30 June 2020. Fixed factory overhead costs are $1 056 000 per year, and the annual fixed selling and...
-
Aussie Sporting Company Pty Ltd produces two types of sporting balls: basketballs and footballs. During the year ended 30 June 2019 it sold the balls in the proportion of three basketballs for every...
Study smarter with the SolutionInn App