Reference no: EM13901108
Moroney’s Cycles sells, repairs, and customizes motorcycles. They stock Harley Davidson, Yamaha Custom, and also have a limited number of KTM Motocross Bikes available for sale. The average Harley costs $8,000, a Yamaha Custom costs $6,000, and a KTM costs $3000. They sell Harleys on average for $10,000, Yamaha Customs for $7500, and KTMs for $3700. The fleet manager has $50,000 this month to bring in new bikes. Based on past sales and the shop’s primary clients, the fleet manager wants to stock at least twice as many Harleys as the other two combined. The main showroom has room for 20 new bikes this month. Each bike must have a service, a maintenance check, and a road test. This takes 8 hours for a Harley, 10 hours for a Yamaha Custom, and 7 hours for a KTM. The service manager estimates that his employees have 125 hours available this month.
Formulate this problem as a Linear Program in standard form.
Solve using Excel Solver and answer the following questions.
1. What is the breakdown of Harleys, Yamahas, and KTMs that should be bought and sold this month?
2. Should Moroney’s try to increase the budget for purchasing bikes, increase space to stock bikes, or increase labor hours for service and testing? Why?
3. If Moroney’s stocked a cheaper motocross bike for $1750 that sold for $3000, would this affect the original solution?
4. Is it worth hiring an additional mechanic for 20 hours at $7 per hour? Why or why not?
|
A business planner and accountant
: You are a business planner and accountant. Part of your expertise is in helping prospective business owners evaluate the various manufacturing and supplier options available based on the product they manufacture. You have a long history of working wi..
|
|
Prepare a statement of services produced in good form
: Prepare a statement of services produced in good form. What if HHH planned to purchase $30,000 of direct materials?
|
|
What is happening at thus part of the supply chain
: Achme's order variance is 800, and the variance of orders of its supplier is 750. What is happening at thus part of the supply chain....
|
|
Depict three elements that may influence the monetary
: Depict three elements that may influence the monetary consequences of a firm directing business globally which could at last effect the execution bond account?
|
|
Problem as a linear program in standard form
: Moroney’s Cycles sells, repairs, and customizes motorcycles. They stock Harley Davidson, Yamaha Custom, and also have a limited number of KTM Motocross Bikes available for sale. What is the breakdown of Harleys, Yamahas, and KTMs that should be boug..
|
|
Congress and state legislatures exercise
: What are the two principal ways in which Congress and state legislatures exercise oversight of administrative agencies? -In what ways does the budgeting process lend itself to political control of administrative policymaking by the executive and leg..
|
|
What ratio of electric force to magnetic force experienced
: What is the total force experienced by the 800-nC charge? What is the ratio of electric force to magnetic force experienced by the 400-nC charge? What is the total force acting on the 400-nC charge? Is the total force acting on the two charges the..
|
|
Find the minimum yearly total system cost when shortages
: A manufactured product has a constant monthly demand of 1,200 units. The machine used to manufacture this product has a constant yearly production rate of 18,000 units and a setup cost of $120. The unit variable production cost is $100 and the annual..
|
|
What are the differences between facts and inferences
: For this reflection activity, pick five of the following seven questions to respond to with examples for each. These are foundational concepts that will help you be successful in this course. What is the relationship between careful observation and c..
|