Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Part 1: Complete Part 1 on its own worksheet. Flintstone Company is planning to spend up to $4,000,000 on new delivery trucks. Flintstone has decided
Part 1: Complete Part 1 on its own worksheet. Flintstone Company is planning to spend up to $4,000,000 on new delivery trucks. Flintstone has decided to purchase two different models of trucks and are trying to decide how many of each model to purchase. The two models are Foot-Power and Dino-Speed. The Foot-Power trucks cost $42,000 each and the Dino-Speed trucks cost $85,000 each. To meet the requirements of delivering frozen steaks, Flintstone must purchase at least 9 Foot-Power trucks. Flintstone's annual insurance budget is $450,000. The annual insurance cost for each Foot-Power truck is $13,000. The annual insurance cost for each Dino-Speed truck is $10,000. Each Basic truck can make 30,000 deliveries per year. Each Refrigerated truck can make 100,000 deliveries per year. Requirement: 1. Use solver to determine how many Basic trucks and Refrigerated trucks should be purchased in order to maximize annual deliveries while meeting all of the constraints. 2. When using solver, create the Answer Report. a. More the answer report to the right of the Part 1 worksheet
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started