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

Another question on Business

Business, 21.06.2019 22:30

True or false: banks are required to make electronically deposited funds available on the same day of the deposit

Answers: 2

Answer

Business, 22.06.2019 12:30

Sales at a fast-food restaurant average $6,000 per day. the restaurant decided to introduce an advertising campaign to increase daily sales. to determine the effectiveness of the advertising campaign, a sample of 49 days of sales were taken. they found that the average daily sales were $6,300 per day. from past history, the restaurant knew that its population standard deviation is about $1,000. if the level of significance is 0.01, have sales increased as a result of the advertising campaign? multiple choicea)fail to reject the null hypothesis.b)reject the null hypothesis and conclude the mean is higher than $6,000 per day.c)reject the null hypothesis and conclude the mean is lower than $6,000 per day.d)reject the null hypothesis and conclude that the mean is equal to $6,000 per day.expert answer

Answers: 3

Answer

Business, 22.06.2019 16:20

Carlos hears juan and rita’s complaints about the new employees with whom they have to work with, as well as their threats to quit the company. if carlos were to reassign juan and rita to new, unique roles and separate them from the ronny and bill, it would signal that carlos has moved into the stage of managing resistance.

Answers: 3

Answer

Business, 22.06.2019 20:50

1. which one of the following would be an example of a supply-side market failure? a. a gas station is slowly leaking diesel fuel from its underground tanks, and after the leak is discovered, the business immediately cleans up the pollution at its own expense. b. a gas station is slowly leaking diesel fuel from its underground tanks, but the state uses taxpayer money to clean up the pollution rather than requiring the business to pay. c. your business wants to attract repeat customers by putting on a customer-appreciation picnic at a public park, but you decide not to because you couldn't prevent noncustomers from consuming the food and entertainment you provided. d. everyone rushes to the local retail outlet at midnight on the day of the release of a new video game console, and the store runs out before everyone is able to buy one.

Answers: 1

Answer

You know the right answer?

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

Questions