Blue Raider Toy Company is planning a huge promotion for Mighty Toys action figures during the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Blue Raider Toy Company is planning a huge promotion for Mighty Toys action figures during the upcoming holiday season. As the company's purchasing manager, your job is to determine the best way to purchase these toys from the manufacturer at the lowest price. After contacting the Mighty Toys manufacturer, you learned that volume discounts and discounts for - preseason orders are available on the Mighty Toys product line. You need to determine the best product mix based on the following information. The Blue Raider Urban Adventure set is the first item that most people will buy. Customers can also purchase the optional Super Action kit, which can be attached to the Blue Raider Urban Adventure set. Another companion set, the Blue Raider Outdoor set, has an optional Hiking kit that customers can purchase separately. I The marketing director for MTSU Toy Company, Betty Wright, wants to allocate the purchasing budget of $100,000 maximum among the four toys. Since the Super Action kit and the Hiking kit are accessories, Betty does not want to purchase more Super Action kits than Blue Raider Urban Adventure sets and does not want to purchase more Hiking kits than Blue Raider Outdoor sets. She also wants to purchase at least half as many Blue Raider Outdoor sets as Blue Raider Urban Adventure sets. The minimum number of any specific toy to be purchased is 250. She wants you to purchase at least 7,250 total items. All purchases must be for a whole item-no fractions of an item can be purchased. Since you are purchasing the Mighty Toys early, you must consider the cost of storing the toys in the MISU Toy warehouse until the holiday sales season begins. Your objective is to maximize the profit on all four toys. Complete the following: 1 Open the workbook named Mighty.xlsx and save it as Mightyloysiyour last name).xlsx 2. Create a new worksheet called Lookup to the right of Purchase Plan. In the Lookup sheet, enter your name in cell A1, and create a table that has monetary information on each of the toys: Blue Raider Urban Adventure Set has a retail price of $19.95, a unit cost of $15.36, and a storage cost of $.15. Blue Raider Toy Company is planning a huge promotion for Mighty Toys action figures during the upcoming holiday season. As the company's purchasing manager, your job is to determine the best way to purchase these toys from the manufacturer at the lowest price. After contacting the Mighty Toys manufacturer, you learned that volume discounts and discounts for - preseason orders are available on the Mighty Toys product line. You need to determine the best product mix based on the following information. The Blue Raider Urban Adventure set is the first item that most people will buy. Customers can also purchase the optional Super Action kit, which can be attached to the Blue Raider Urban Adventure set. Another companion set, the Blue Raider Outdoor set, has an optional Hiking kit that customers can purchase separately. I The marketing director for MTSU Toy Company, Betty Wright, wants to allocate the purchasing budget of $100,000 maximum among the four toys. Since the Super Action kit and the Hiking kit are accessories, Betty does not want to purchase more Super Action kits than Blue Raider Urban Adventure sets and does not want to purchase more Hiking kits than Blue Raider Outdoor sets. She also wants to purchase at least half as many Blue Raider Outdoor sets as Blue Raider Urban Adventure sets. The minimum number of any specific toy to be purchased is 250. She wants you to purchase at least 7,250 total items. All purchases must be for a whole item-no fractions of an item can be purchased. Since you are purchasing the Mighty Toys early, you must consider the cost of storing the toys in the MISU Toy warehouse until the holiday sales season begins. Your objective is to maximize the profit on all four toys. Complete the following: 1 Open the workbook named Mighty.xlsx and save it as Mightyloysiyour last name).xlsx 2. Create a new worksheet called Lookup to the right of Purchase Plan. In the Lookup sheet, enter your name in cell A1, and create a table that has monetary information on each of the toys: Blue Raider Urban Adventure Set has a retail price of $19.95, a unit cost of $15.36, and a storage cost of $.15.
Expert Answer:
Answer rating: 100% (QA)
1 Open the workbook named Mighty Toys and save it as MightyLNYLastnamexls... View the full answer
Related Book For
Automation Production Systems and Computer Integrated Manufacturing
ISBN: 978-0132393218
3rd edition
Authors: Mikell P.Groover
Posted Date:
Students also viewed these finance questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Explain why a decline in investment spending caused by a change in business expectations leads to a fall in consumer spending.
-
Taraz Company paid $500,000 to purchase the following portfolio of intangibles with estimated fair values as indicated: Estimated Fair Value Internet domain name . . . . . . . . . . . . . . . . . . ....
-
Cocaine blocks the reuptake of ________. a. GABA b. Glutamate c. Acetylcholine d. Dopamine
-
Tomlinsons Lumens, Inc. (TLI) is a large manufacturer of lighting fixtures and parts. TLAs Accounting department receives files tomlinsonprices and tomlinsonunits that summarize the price and units...
-
On December 31, 2012, the balances of the accounts appearing in the ledger of Warm Place Furnishings Company, a furniture wholesaler, are as follows.a. Prepare a multiple-step income statement for...
-
Oil flows over both sides of a flat plate. The plate dimensions are W = 250 mm and L = 740 mm. The free stream velocity is U = 4.2 m/s. Calculate the drag force on the plate. U W.
-
Determine the amount of the completed gift, if any, arising from each of the following occurrences. a. A parent sells real estate valued at $1.8 million to an adult child, who pays $1 million in...
-
In the discussion forum, you are expected to participate often and engage in deep levels of discourse. Please post your initial response as early as possible and continue to participate throughout...
-
At its meeting today, the Board decided to increase the cash rate target by 25?basis points to 4.10?per?cent. It also increased the interest rate paid on Exchange Settlement balances by 25?basis...
-
What is the role of context (background, personality, worldview, culture), emotion, and listening in relationships.
-
You are conducting a study testing whether a childs age is a good predictor of his or her height. You have collected the following data from a random sample of seven children: Age (months) Height...
-
What is an accepted development approach: first, develop a prototype did an initial complete item, and then a final complete item? A) no assessing a system that is not final year olds in accurate...
-
What does our book argue about leisure and GDP? Choice 1 of 4: If we worked like in the past, GDP would be larger, but leisure would be less. Choice 2 of 4: If we worked like in the past, GDP would...
-
Average demand for replacement widgets at LMX is 20 widgets per day with a standard deviation of 4 widgets per day. It takes the company 9 days lead time to receive an order for new widgets. What...
-
2.) Find the Laplace transform of f(t) 7e-St cos 2t +9 sinh2 2t. Use Laplace Table. %3D
-
What is meant by the term coordinate metrology?
-
Develop the form code (first five digits) in the Opitz System for the part illustrated in Figure P18.2.
-
What are the advantages of using a PLC rather than conventional relays, timers, counters, and other hard-wired control components?
-
In a vapour compression refrigeration system, the condition of refrigerant before entering the compressor is (a) saturated liquid (b) wet vapour (c) dry saturated liquid (d) superheated vapour
-
During a refrigeration cycle, heat is rejected by the refrigerant in (a) compressor (b) condenser (c) evaporator (d) expansion valve
-
The highest temperature during the cycle in vapour compression refrigeration system occurs after (a) compression (b) condensation (c) expansion (d) evaporation
Study smarter with the SolutionInn App