Business, 25.08.2021 01:00, jayjayw64

Tots Toys makes a plastic tricycle that is composed of three major components: a handlebar-front wheel-pedal assembly, a seat and frame unit, and rear wheels. Please note that each tricycle requires two rear wheels, the front wheel is included in the front wheel-pedal assembly. The company has orders for 12,000 of these tricycles. Current schedules yield the following information: Requirements:
Component Plastic Time Space Cost to Manufacture Cost to Purchase
Front 3 10 2 8 12
Seat/Frame 4 6 2 6 9
Rear Wheels (each) 0.5 2 0.1 1 3
Available 50000 160000 30000
The company obviously does not have the resources available to manufacture everything needed for the completion of 12000 tricycles so has gathered purchase information for each component.
a) Use Excel's Solver to obtain the optimal solution. How many of each component should be manufactured vs. purchased? What is the overall cost? What are the binding constraints?
b) Upload a screenshot of the spreadsheet that you used to solve this problem.

Answers: 1

Show answers

Other questions on the subject: Business

Business, 22.06.2019 08:00, Shyshy876

3. describe the purpose of the sec. (1-4 sentences. 2.0 points)

Answers: 3

continue

Business, 22.06.2019 08:40, adrian08022

Which of the following is not a characteristic of enterprise applications that cause challenges in implementation? a. they introduce "switching costs," making the firm dependent on the vendor. b. they cause integration difficulties as every vendor uses different data and processes. c. they are complex and time consuming to implement. d. they support "best practices" for each business process and function. e. they require sweeping changes to business processes to work with the software.

Answers: 1

continue

Business, 22.06.2019 15:20, ashleyuchiha123

Gulliver travel agencies thinks interest rates in europe are low. the firm borrows euros at 5 percent for one year. during this time period the dollar falls 11 percent against the euro. what is the effective interest rate on the loan for one year? (consider the 11 percent fall in the value of the dollar as well as the interest payment.)

Answers: 2

continue

Business, 22.06.2019 21:20, haileymaree

1. what are the unique operational challenges to delivering fresh meals? 2. why is speed of delivery so important for delivered meals? what variety of options contribute to this performance metric? 3. how could operations management concepts be utilized to improve the performance of freshly? 4. what are your typical product delivery times? what would be required to speed these up? 5. what are your delivery batch quantities? how could you reduce batch size and reduce delivery cost simultaneously using operations management concepts?

Answers: 2

continue

Do you know the correct answer?

Tots Toys makes a plastic tricycle that is composed of three major components: a handlebar-front whe...