Reference no: EM13760825
A sports manufacturer produces two products: footballs and baseballs. These products can be produced either during the morning shift or the evening shift. The cost of manufacturing the football and the baseball in the morning shift is $20 each, and the cost of manufacturing the football and the baseball in the evening shift is $25 each. The amounts of labor, leather, inner plastic lining, and demand requirements are given as follows:
Resource Football Baseball
Labor (hours/unit) 0.75 2
Leather (pounds/unit) 7 15
Inner plastic lining (pounds/unit) 0.5 2
Total demand (units) 1500 1200
Based on the information about the company, we know that the maximum labor hours available in the morning shift and evening shift are 5,000 hours and 2,000 hours, respectively, per month. The maximum amount of leather available for the morning shift is 15,000 pounds per month and 14,000 pounds per month for the evening shift. The maximum amount of inner plastic lining available for the morning shift is 2,000 pounds per month and 1,500 pounds per month for the evening shift.
Solve the given problem scenario so as to minimize the production cost and determine the number of footballs and baseballs made by this company by formulating and setting up the problem in Excel Solver.
|
Sample of observations falls outside the control limits
: If you see a sample of observations falls outside the control limits of a control chart,
|
|
Item analysis debate
: Include other scholarly resources other than those listed below with appropriate references and in-text citations.
|
|
Determine the warranty liability
: Determine the warranty liability at January 31, the end of the first month of the current year. What accounts are decreased for the warranty work provided in February?
|
|
Storing and retrieving data from csv file
: Storing and retrieving data from CSV file, LSV file, or database, Incorporate all of the following topics covered in lectures: Arrays, Structures, Loops, Conditions
|
|
Problem scenario so as to minimize the production cost
: A sports manufacturer produces two products: footballs and baseballs. These products can be produced either during the morning shift or the evening shift.
|
|
Determine the warranty liability
: Determine the warranty liability at January 31, the end of the first month of the current year. What accounts are decreased for the warranty work provided in February?
|
|
Forensic tools
: Example of a way in which an investigation can be corrupted by not using computer forensics tools.
|
|
Ending balance in manufacturing overhead account
: During the month, direct materials amounting to $20,000 and indirect materials amounting to $5,000 was issued to production. What is the ending balance in the manufacturing overhead account for the month of October?
|
|
Ibms culture changed from formal-stable and impermanent
: If you calculate the person-hours devoted to IBM's team projects, they amount to more than 180,000 hours of management time each year. Do you think this is a wise investment of IBM's human resources? Why or why not? Why do you think IBM's culture cha..
|