subject
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.

ansver
Answers: 1

Another question on Business

question
Business, 21.06.2019 21:00
You decide that structural changes must be made at holden evans immediately to deal with the additional product lines. equipment and employees will have to be moved around to optimize production of all of the products in house. this shouldn't be too difficult because many of the vitamins and supplements are produced using similar processes. you have several options available to facilitate this process. which of the following methods do you think is the best choice? select an option from the choices below and click submit. because the changes may result in the loss of several key employees, you hire outside consultants who specialize in hr law. this way any employee terminations will not result in lawsuits. you select an outside consulting firm that your company has never worked with before, but it has a reputation for using new technology in product lines that are similar to yours. you select several trusted managers to facilitate the transition of operations from overseas. these individuals can gather information and also smooth any rough spots that may occur.
Answers: 3
question
Business, 21.06.2019 21:40
Tandard product costs deerfield company manufactures product m in its factory. production of m requires 2 pounds of material p, costing $4 per pound and 0.5 hour of direct labor costing, $10 per hour. the variable overhead rate is $8 per direct labor hour, and the fixed overhead rate is $12 per direct labor hour. what is the standard product cost for product m? direct material answer direct labor answer variable overhead answer fixed overhead answer standard product cost per unit answer
Answers: 1
question
Business, 22.06.2019 11:00
%of the world's population controls approximately % of the world's finances (the sum of gross domestic products)" quizlket
Answers: 1
question
Business, 22.06.2019 12:50
Jallouk corporation has two different bonds currently outstanding. bond m has a face value of $50,000 and matures in 20 years. the bond makes no payments for the first six years, then pays $2,100 every six months over the subsequent eight years, and finally pays $2,400 every six months over the last six years. bond n also has a face value of $50,000 and a maturity of 20 years; it makes no coupon payments over the life of the bond. the required return on both these bonds is 10 percent compounded semiannually. what is the current price of bond m and bond n?
Answers: 3
You know the right answer?
Tots Toys makes a plastic tricycle that is composed of three major components: a handlebar-front whe...
Questions
question
Mathematics, 23.01.2020 18:31
question
Mathematics, 23.01.2020 18:31
question
Computers and Technology, 23.01.2020 18:31
Questions on the website: 13722362