Reference no: EM13954049
Scenario:
Business decisions are often subject to constraints or business rules to solve business problems. Excel’s Solver can be used to develop decisions, such as maximizing profit or reducing costs.
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.
|
Estimate the nominal interest rate on a treasury bond
: A corporate bond has a nominal interest rate of 12 percent. This bond is not very liquid and consequently requires a 2 percent liquidity premium. The bond is of low quality and thus has a default risk premium of 2.5 percent. The bond has a remaini..
|
|
Create a strategy to ensure workforce diversity
: Create a strategy to ensure workforce diversity, recruitment, and planning. Include details on how this strategy will help to keep human resource costs down. Be clear and concise in explaining the components of your strategy. Include detail and ratio..
|
|
Estimate cost per unit in a batch vs job shop process
: Why is it easier to estimate cost per unit in a batch vs. a job shop process? What is the tradeoff between fixed and variable costs in a job shop process, and why does it occur?
|
|
Which plan will students eat the most
: A university is deciding between two meal plans. One plan charges a fixed fee of $600 per semester and allows students to eat as much as they want. The other plan charges a fee based on the quantity of food consumed. Under which plan will students..
|
|
Maximizing profit or reducing costs
: Business decisions are often subject to constraints or business rules to solve business problems. Excel’s Solver can be used to develop decisions, such as maximizing profit or reducing costs. ABCD is a sports equipment manufacturer. They need to find..
|
|
Standard deviation of daily demand
: For the following scenario, find the order point (R) needed to provide 95% service level: Average daily demand = 27 units. Standard deviation of daily demand = 5.4 units. Lead time = 3 days (constant). Be sure to display any important intermediate ca..
|
|
Monthly demand for an inventory item currently averages
: Monthly demand for an inventory item currently averages 170 units. The annual carrying cost is $10 per unit. Ordering cost is $70 per order. This information applies to all of the questions on this page.
|
|
Effect this will have on average inventory levels
: Explain what should happen to the order quantity in an order point (Q,R) system, and the time between orders in a periodic review (P,T) system, as the fixed cost per order (S) increases relative to other cost parameters. Explain the effect this will ..
|
|
What impact would policy have on level of cycle inventory
: For a repetitive ordering situation (with reorder points), describe the inventory control policy that would prevent shortages while carrying minimal inventory, if fixed ordering costs (S) and quantity discounts were negligible and thus not important ..
|