Art Glass Productions, a producer of decorative glass gift items, wants to expand into a new territory.
Question:
Art Glass Productions, a producer of decorative glass gift items, wants to expand into a new territory. Ma n agers at Art Glass know that unit sales in the new territory will be affected by consumer response to the products. But sales will also be affected by which combination of wholesalers and retailers Art Glass selects. There is a choice between two wholesalers. One wholesaler, Giftware Distributing, is a merchant wholesaler that specializes in gift items; it sells to gift shops, department stores, and some mass-merchandisers. The other wholesaler, Margaret Degan & Associates, is a manufacturers’ agent who calls on many of the gift shops in the territory. Art Glass makes a variety of glass items, but the cost of making an item is usually about the same—$5.20 a unit. The items would sell to Giftware Distributing at $12.00 each—and in turn the merchant whol e saler’s price to retailers would be $14.00—leaving Giftware with a $2.00 markup to cover costs and profit. Giftware Distributing is the only reputable merchant wholesaler in the territory, and it has agreed to carry the line only if Art Glass is willing to advertise in a trade magazine aimed at retail buyers for gift items. These ads will cost $8,000 a year. As a manufacturers’ agent, Margaret Degan would cover all of her own expenses and would earn 8 percent of the $14.00 price per unit charged the gift shops. Individual orders would be shipped directly to the retail gift shops by Art Glass, using United Parcel Service (UPS). Art Glass would pay the UPS charges at an average cost of $2.00 per item. In contrast, Giftware Distributing would anticipate demand and place larger orders in advance. This would reduce the shipping costs, which Art Glass would pay, to about $.60 a unit. Art Glass’ marketing manager thinks that Degan would only be able to sell about 75 percent as many items as Giftware Distributing—since she doesn’t have time to call on all of the smaller shops and doesn’t call on any department stores. On the other hand, the merchant wholesaler’s demand for $8,000 worth of supporting advertising requires a significant outlay. The marketing manager at Art Glass decided to use a spreadsheet to determine how large sales would have to be to make it more profitable to work with Giftware and to see how the different channel arrang e ments would contribute to profits at different sales levels. a. Given the estimated unit sales and other values shown on the initial spreadsheet, which type of wh o lesaler would contribute the most profit to Art Glass Productions? b. If sales in the new territory are slower than expected, so that the merchant wholesaler was able to sell only 3,000 units—or the agent 2,250 units— which wholesaler would contribute the most to Art Glass’ pro f its? ( Note: Assume that the merchant wholesaler only buys what it can sell; that is, it doesn’t carry extra i n ventory beyond what is needed to meet demand.) c. Prepare a table showing how the two wholesalers’ contributions to profit compare as the quantity sold varies from 3,500 units to 4,500 units for the merchant wholesaler and 75 percent of these numbers for the manufacturers’ agent. Discuss these results. ( Note: Use the analysis feature to vary the quantity sold by the merchant wholesaler, and the program will compute 75 percent of that quantity as the estimate of what the agent will sell.)
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 72% (11 reviews)
Given the expected sales quantity 4500 units by the merchant wholesaler or 3375 units for the agent ...View the full answer
Answered By
Ashington Waweru
I am a lecturer, research writer and also a qualified financial analyst and accountant. I am qualified and articulate in many disciplines including English, Accounting, Finance, Quantitative spreadsheet analysis, Economics, and Statistics. I am an expert with sixteen years of experience in online industry-related work. I have a master's in business administration and a bachelor’s degree in education, accounting, and economics options.
I am a writer and proofreading expert with sixteen years of experience in online writing, proofreading, and text editing. I have vast knowledge and experience in writing techniques and styles such as APA, ASA, MLA, Chicago, Turabian, IEEE, and many others.
I am also an online blogger and research writer with sixteen years of writing and proofreading articles and reports. I have written many scripts and articles for blogs, and I also specialize in search engine
I have sixteen years of experience in Excel data entry, Excel data analysis, R-studio quantitative analysis, SPSS quantitative analysis, research writing, and proofreading articles and reports. I will deliver the highest quality online and offline Excel, R, SPSS, and other spreadsheet solutions within your operational deadlines. I have also compiled many original Excel quantitative and text spreadsheets which solve client’s problems in my research writing career.
I have extensive enterprise resource planning accounting, financial modeling, financial reporting, and company analysis: customer relationship management, enterprise resource planning, financial accounting projects, and corporate finance.
I am articulate in psychology, engineering, nursing, counseling, project management, accounting, finance, quantitative spreadsheet analysis, statistical and economic analysis, among many other industry fields and academic disciplines. I work to solve problems and provide accurate and credible solutions and research reports in all industries in the global economy.
I have taught and conducted masters and Ph.D. thesis research for specialists in Quantitative finance, Financial Accounting, Actuarial science, Macroeconomics, Microeconomics, Risk Management, Managerial Economics, Engineering Economics, Financial economics, Taxation and many other disciplines including water engineering, psychology, e-commerce, mechanical engineering, leadership and many others.
I have developed many courses on online websites like Teachable and Thinkific. I also developed an accounting reporting automation software project for Utafiti sacco located at ILRI Uthiru Kenya when I was working there in year 2001.
I am a mature, self-motivated worker who delivers high-quality, on-time reports which solve client’s problems accurately.
I have written many academic and professional industry research papers and tutored many clients from college to university undergraduate, master's and Ph.D. students, and corporate professionals. I anticipate your hiring me.
I know I will deliver the highest quality work you will find anywhere to award me your project work. Please note that I am looking for a long-term work relationship with you. I look forward to you delivering the best service to you.