Set up your spread sheet in Excel’s Solver to determine the optimum number of each product
ABCD is a sports equipment manufacturer. They need to find out the ideal number of basketballs and footballs to manufacture to maximize Net Profit. The capacity of production, cost, labor needed, time needed, 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 could be produced: Min 30,000 – Max 60,000 The number of footballs that could be produced: Min 20,000 – Max 40,000 Ratio of basketballs / footballs: 1.5 – 1.5 Basketball selling Price: $14.00 Football Selling Price: $11.00 Tax Rate: 0.28% Time to manufacture a Basketball: 0.5 hrs. Time to manufacture a Football: 0.3 hrs. Cost of labor — 1 machine hour: $6.00 Cost of material– 1 Basketball: $2.00 Cost of material– 1 Football: $1.25 Set up your spread sheet in Excel’s Solver to determine the optimum number of each product [i.e. Footballs and Basketballs] that should be manufactured to maximize the profit.
PLACE THIS ORDER OR A SIMILAR ORDER WITH STUDENT HOMEWORKS TODAY AND GET AN AMAZING DISCOUNT
The post Set up your spread sheet in Excel’s Solver to determine the optimum number of each product appeared first on STUDENT HOMEWORKS .
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!
NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
