(Solution Download) If Problem 10 58 Budgeting and Sustainability has not already been

If Problem 10-58 (Budgeting and Sustainability) has not already been assigned, it can be assigned here.
In Problem 10-58
Neat-and-Clean handles both commercial laundry and individual customer dry cleaning. The company's dry-cleaning process involves emitting a pollutant into the air. In addition, the commercial laundry and dry cleaning services produce sediments and other elements that must receive special treatment before disposal. David Duncan, Neat-and-Clean's owner, is concerned about the cost of dealing with increasingly stringent laws and environmental regulations. Recent legislation in the state requires Neat-and-Clean to reduce the amount of its air pollution emissions.
Variable processing costs per 5-pound batch of laundry for Neat-and-Clean are estimated as follows (on average):

The materials that are currently being used for dry-cleaning purposes have an unfortunate effect: excessive emissions that can be considered toxic in nature. The company can switch to a more environmentally friendly cleaning compound, which is currently selling at a price equal to $2.25 per pound of laundry. (For simplicity, assume that this cost applies to both commercial and individual laundry.) The owner is hesitant to switch over to the new cleaning compound because of the increase in processing cost per load of laundry. At the same time, he is acutely aware that in a neighboring town, a competitor business was subjected to a $60,000 fine by the relevant state authority. As such, Duncan is concerned that if he doesn't switch to the new compound his business may be subject to a similar fine.
1. Based solely on the data provided above, does it make fi nancial sense for Duncan to switch to the more environmentally friendly cleaning compound? (Assume for this question that other costs are unaffected by this decision. Also, assume a one-year planning horizon.)
2. Independent of your answer to requirement 1 above, assume that Duncan "wants to do the right thing," both for his employees and the environment. As such, he chooses to switch to the new cleaning compound. The seller of this compound has suggested that, consistent with continuous improvement (kaizen) budgeting, it may be possible to reduce both labor costs and electricity costs by 1% per month starting with month #1 in a 12-month planning horizon. How close to being indifferent between incurring the fine and incurring the increased processing costs would Neat-and-Clean be after one year? 3. Use Goal Seek in Excel to answer each of the following questions, independently:
a. What is the monthly cost-reduction rate (%) that would equate the net increase in year-one processing costs with the amount of the anticipated fi ne ($60,000)?
b. What is the cost per pound for the new compound that would equate the anticipated fine ($60,000) with year-one processing costs, assuming no kaizen budgeting plan (i.e., no reduction in the labor and electricity processing costs over time)? What conclusion can you draw based on this analysis?
4. What options (i.e., operational changes) secure the cost savings referenced above in requirement 2?
5. What other considerations (both qualitative and quantitative) might affect the ultimate decision by David Duncan?


About this question:

Pay using PayPal (No PayPal account Required) or your credit card. All your purchases are securely protected by .