please answer in EXCEL only using goal seek within 30 minutes. A manufacturer can produce an item for $139/unit with afixed cost of $56,034. The alternative is to outsource theproduction to a supplier at a unit cost of $182/unit. Determinethe BEP (Break - Even Point) using GOALSEEK in excel

The break-even point is the point at which the total cost of production equals the total revenue…

Answered: A manufacturer can produce an item for…

MARKETING 2018

19th Edition

ISBN:9780357033753

Author:Pride

Publisher:Pride

Chapter15: Retailing, Direct Marketing, And Wholesaling

Section15.1: L.l.bean: Open 24/7, Click Or Brick

Problem 3VC

See similar textbooks

Similar questions

Alison's Accessories is a high volume worldwide fashion house with outlets in 65 countries. Sadly, space does not permit an exhaustive list but once the test is over, check out their website. Kalil, the supply chain manager is conducting her usual thorough analysis of her final four candidates for supplier and has developed the following tables of pertinent costs and other shipping metrics. Regardless of supplier, Alison's Accessories will operate 220 days per year and has forecast annual demand of 250,000 units. Kalil has obtained quotes for three different shipment sizes (Freight Costs table). All costs are in US Dollars. Table 1 Unit costs Supplier Price/Unit Carrying Cost A 123 22 B 125 19 C 126 18 D 100 40 Annual Freight Costs Supplier 15,000 units 25,000 units 50,000 units A 380,000 260,000 237,000 B 615,000 547,000 470,000 C 285,000 240,000 200,000 D 380,000 260,000 237,000 Other Costs Supplier Lead Time Annual Admin Costs A 30 250,000 B 15 275,000 C 7 225,000 D 90…
Gabriela Manufacturing must decide whether to insource(make) or outsource (buy) a new toxic-free carpet cleaner thatworks with its Miracle Carpet Cleaning Machine. If it decides toinsource the product, the process would incur $300,000 of annualfi xed costs and $1.50 per unit of variable costs. If it is outsourced,a supplier has off ered to make it for an annual fi xed cost of$120,000 and a variable cost of $2.25 per unit in variable costs.(a) Construct a base-case spreadsheet model that shows bothof these alternatives side-by-side. Use the same number ofunits (stored in a single cell) to drive the calculations.(b) If the expected annual demand for the new cleaner is300,000 units, what would you recommend that GabrielaManufacturing do? Provide evidence to support yourrecommendation.(c) Use Goal Seek to fi nd the indiff erence point (where totalcosts are equal) between these two alternatives.
Gabriela Manufacturing must decide whether to insource(make) or outsource (buy) a new toxic-free carpet cleaner thatworks with its Miracle Carpet Cleaning Machine. If it decides toinsource the product, the process would incur $300,000 of annualfi xed costs and $1.50 per unit of variable costs. If it is outsourced,a supplier has off ered to make it for an annual fi xed cost of$120,000 and a variable cost of $2.25 per unit in variable costs.(a) Construct a base-case spreadsheet model that shows bothof these alternatives side-by-side. Use the same number ofunits (stored in a single cell) to drive the calculations.(b) If the expected annual demand for the new cleaner is300,000 units, what would you recommend that GabrielaManufacturing do? Provide evidence to support yourrecommendation.(c) Use Goal Seek to fi nd the indiff erence point (where totalcosts are equal) between these two alternatives. (Hint: GoalSeek can work only with a single “Set cell.”) Create a cell inyour model that…
1. As a logistic manager, please advise the relationship between logistics and supply chain management? 2. You are the owner of fresh fruit store; is there a way you can adapt the omni-channel. Please explain the reason why or why not?
Supply chain management covers the planning and execution of processes required to execute a product's flow, from acquiring goods and materials through production and distribution to the final customer. In what way does the company reach its maximum efficiency and how can we determine the improvement in the ultimate outcome?
draw two diagrams,one depicting the supply chain for those products sourced in china and the other depicting the bags produced in san francisco.show all major steps,including raw material,manufacturing,finished goods,distribution inventory and transportation. other than manufacturing cost,what other cost should timbuk2 consider when making the sourcing decision
Hi there , can you please please assist with the following question below Using the example of a catering company, i.e., making and selling food, explain the first three components of supply chain management in relation to the above example. required :Explain each of this components: 1. Planning 2 Sourcing and 3.Making• Explain each component in relation to the example provided.
Draw two diagrams, one depicting the supply chain for those products sourced in China and the other depicting the bags produced in San Francisco. Show all the major steps, including raw material, manufacturing, finished goods, distribution inventory, and transportation. Other than manufacturing cost, what other costs should Timbuk2 consider when making the sourcing decision?
Define the term redeployment? What significance does redeployment have?
Outsourcing is referred to as the process of transferring a business activity, including the relevant assets,to a third party. Outsourcing of manufacturing activities is always debatable. As the purchasing manageranalyse the concept of outsourcing and advice on the most suitable option for Dysons in terms ofoutsourcing of their manufacturing. (Using the attached)
Determine which factor of production is needed in the following problem. 1.The ABM manufacturing Co.hired a gardener.He uses a lawn mower for landscaping.Which factor of production would you consider this machine? 2.The owner of the company withdrew cash for the salaries of thw employees.which factor of production would you consider cash on hand? 3.The top manager of the firm said "the great ideas,consepts and emotional determination of a person to produce something that consumers want to buy" is very important for the company.What factor of production describes the ability to create great ideas? 4.The farmers planted pineapple cutting in the vacant area located in their locality.Which factor of production would you consider a pineapple plantation?
A line of furniture is made by the Drazal Company in South Carolina and is being considered for outsourcing to China. The unit manufacturing costs in the U.S. are:Unit Cost of Goods SoldDirect labor 53Materials 122Overhead 49Total 224When produced in China, direct labor will be 60 percent of the U.S. cost and overhead will also be 60 percent of the U.S. cost, since it consists mostly of salaries. Materialscosts will be 10 percent lower in China. Transporting the furniture from China will cost $27,000 for seven containersto transport the annual supply of 500 units from the factory in China to the Drazal warehouse in the U.S. by rail, truck, and sea. To ensure quality, it will cost $12,000 per year to mmonitor the supplier and inspect the units in China before they are sent. The cost of administering the contract is $5,000 per year.a. What are the total costs of supplying this product from China?b. What risks are associated with the Chinese supplier?c. Should the product be outsourced to…

SEE MORE QUESTIONS

Recommended textbooks for you

MARKETING 2018

Marketing

ISBN:

9780357033753

Author:

Pride

Publisher:

CENGAGE L

MARKETING 2018

Marketing

ISBN:

9780357033753

Author:

Pride

Publisher:

CENGAGE L

SEE MORE TEXTBOOKS

A manufacturer can produce an item for $139/unit with a fixed cost of $56,034. The alternative is to outsource the production to a supplier at a unit cost of $182/unit. Determine the BEP (Break - Even Point) using GOALSEEK in excel