Description Case studies are used to enable you to apply new concepts, use the tools you have mastered, and improve the technical skills you have attained. Through the individual case studies you will discover for yourself the usefulness of quantitative problem solving methods, how to apply them in practice, and their benefit to organizational decision-makers. In this case study, you will act as a consultant for a manufacturing company looking to maximize net profit generated by a production facility subject to a number of production constraints. You will develop a linear programming model and solve it using Excel’s Solver tool.
Further, you will interpret the generated Answer and Sensitivity Reports to develop recommendations for optimal product mix and future profitability of the company. Both a written report and an Excel spreadsheet model are required to be submitted. Scenario ABCD, Ltd. is a sports equipment manufacturer that owns and operates a number of manufacturing plants across the country. The company operates one particular plan where both footballs and basketballs are manufactured. While the company has some flexibility to move manufacturing effort between basketball and football production, the current processes do impose limits on the minimum and maximum number of each ball that can be produced. Production capacity, cost of materials, labour costs, manufacturing time, and other known constraints are provided below: Production Capability and Constraints (All unit costs are in $ and time in hours) • Total Machine hours available: Min 39,000 – Max 40,000 hrs.
• The number of basketballs that can be produced: Min 30,000 – Max 60,000 • The number of footballs that can be produced: Min 20,000 – Max 40,000 • Time to manufacture a Basketball: 0.5 hrs. • Time to manufacture a Football: 0.3 hrs. • Cost of labour -- 1 machine hour: $6.00 • Cost of material-- 1 Basketball: $2.00 • Cost of material-- 1 Football: $1.25 ABCD believes it can sell each basketball for $14.00 and each football for $11.00. Further, the company believes that cost of material and labour costs will not change over the next production cycle. The corporate tax rate is 28%. The company wants to determine the ideal number of basketballs and footballs to manufacture that will maximize the facility’s net profit after taxes.
PROBLEM-SOLVING APPLICATION CASE (PSAC)Without George Zimmer, Does Men’s Wear house Like the Way It Looks?What happens when a company fires its own founder, and the found...Jul 22 2020
The rhetoric of the American Revolution stresses ideas such as freesom, liberty,and democracy. Discuss the impact of these revolutionary ideas on American society and how...Feb 01 2020
What is the role of users in information security?15) Explain how you would create a strong password.16) Explain the necessary password etiquette to be followed by users ...Dec 07 2019
Conigan Box Company produces pencils that are sold in bundles of 1000 pencils per box. The market is highly competitive, with pencils currently selling for $100 per box. ...Jun 04 2020
The number of customers arriving at customer service of a department store follows a Poisson distribution with a mean of λ =4.0 per time unit. A time unit has 10 minutes....Apr 21 2020
How are credit unions different from other financial institutions? 2) Why are mutual funds popular among investors? How does a money market mutual fund differ from a sto...Mar 21 2020
Refer to the data in Exercise 10–25, regarding Canandaigua Container Company. Prepare journal entries to: In Exercise 10–25, Canandaigua Container Company manufactures re...Jun 27 2020
A simply supported beam of rectangular cross section of size 200*300 mm (deep) supports a uniformly distributed load of 6 kN/m over an effective span of 4 m. Calculate th...May 16 2020
Total Cash (Dr.) =Total Sales Discounts (Dr.) = Total Sales (Cr.) =Total Accounts Receivable (Cr.) =Total Notes Payable (Cr.)=help_outlineAug 23 2020
Assume that for a particular company the only temporary difference for tax-effect accounting purposes relates to the depreciation of a newly acquired machine The machine ...Mar 24 2020
Welcome to MyCourseHelp Services, World's leading Academic solutions provider with Millions of Happy Students.