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

Other questions on the subject: Business

image
Business, 22.06.2019 11:00, hadwell34
You are attending college in the fall and you need to purchase a computer. you must finance the purchase because your parents will not purchase it for you, and you do not have the cash on hand to purchase it. in blank #1 determine which type of credit would you use to finance your purchase (installment, non-installment, or revolving credit). (2 points) in blank #2 defend your credit choice by explaining why your financing option is the best option for you. (2 points) in blank #3 explain why you selected that credit option over the other two options available. (2 points)
Answers: 3
image
Business, 22.06.2019 11:30, khynia11
Given the following information about the closed economy of brittania, what is the level of investment spending and private savings, and what is the budget balance? assume there are no government transfers. gdp=$1180.00 million =$510.00 million =$380.00 million =$280.00 million
Answers: 3
image
Business, 22.06.2019 14:20, ssalusso7914
Cardinal company is considering a project that would require a $2,725,000 investment in equipment with a useful life of five years. at the end of five years, the project would terminate and the equipment would be sold for its salvage value of $400,000. the company’s discount rate is 14%. the project would provide net operating income each year as follows: sales $2,867,000 variable expenses 1,125,000 contribution margin 1,742,000 fixed expenses: advertising, salaries, and other fixed out-of-pocket costs $706,000 depreciation 465,000 total fixed expenses 1,171,000 net operating income $571,000 1. which item(s) in the income statement shown above will not affect cash flows? (you may select more than one answer. single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. any boxes left with a question mark will be automatically graded as incorrect.) (a)sales (b)variable expenses (c) advertising, salaries, and other fixed out-of-pocket costs expenses (d) depreciation expense 2. what are the project’s annual net cash inflows? 3.what is the present value of the project’s annual net cash inflows? (use the appropriate table to determine the discount factor(s) and final answer to the nearest dollar amount.) 4.what is the present value of the equipment’s salvage value at the end of five years? (use the appropriate table to determine the discount factor(s) and final answer to the nearest dollar amount.) 5.what is the project’s net present value? (use the appropriate table to determine the discount factor(s) and final answer to the nearest dollar amount.)
Answers: 2
image
Business, 22.06.2019 20:20, martinezarielys17
As you have noticed, the demand for flip phones has drastically reduced, and there are only a few consumer electronics companies selling them at extremely low prices. also, the current buyers of flip phones are mainly categorized under laggards. which of the following stages of the industry life cycle is the flip phone industry in currently? a. growth stage b. maturity stage c. decline stage d. commercialization stage
Answers: 2
You know the right answer?
Tots Toys makes a plastic tricycle that is composed of three major components: a handlebar-front whe...

Questions in other subjects:

Konu
Mathematics, 06.10.2020 23:01