Reference no: EM13951767
Cheryl Sounders, the owner of Abruzzi, is currently developing a budget spreadsheet to explore the impact of various sales goals on production. In 2011, the company had monthly sales as follows:MonthSales (gallons)
January ..........9,400
February ........9,200
March .........9,000
April ...........8,800
May ...........8,100
June ...........8,500
July ...........8,800
August ........8,500
September .......9,000
October ........9,300
November .......9,200
December .......9,600
At a planning meeting in November 2011, Jay Peters, the marketing manager for Abruzzi, told Cheryl that he expected monthly sales to increase by 5 to 15 percent in the coming year. But in late December 2011, Jay rushed into Cheryl's office with some good news.Cheryl, I just had a meeting with Consolidated Restaurants, and they're considering an order for 1,500 gallons each month for all of 2012. Gosh, Cheryl replied, that's an exciting bit of news, but I'm concerned about whether we have the capacity to accept such a large order. I'll prepare budgets assuming we don't get the Consolidated business but we increase monthly sales by 5, 10, or 15 percent. Then I'll assume the Consolidated order comes through, and on top of that we have monthly sales increases of 5, 10, and 15 percent. This should give us a good idea of whether we'll bump up against capacity.Jay thought that this sounded fine, but he wondered whether Cheryl had the time to do this much work. Cheryl indicated that the analysis was relatively easy since she was preparing the budget on a spreadsheet and each analysis would require only a simple change.
Required:
a. Using a spreadsheet, prepare the six monthly budget schedules that Cheryl suggested (i.e., monthly budgets with and without the Consolidated business assuming other sales increases of 5,10,and 15 percent).As a general rule, Cheryl likes to have ending inventory equal to 15 percent of next month's sales. Assume that the company ended 2011 with an inventory of 1,400 gallons of olive oil. In order to calculate ending inventory at the end of December 2012, assume that sales in January 2013 will be the same as December 2012 sales.
b. Suppose that capacity is 12,000 gallons Is the company likely to encounter a capacity problem?
c. Abruzzi sells its oil for $25 per gallon. The variable cost per gallon is $10.What will be the annual impact on profit of obtaining the Consolidated business (assuming there is no capacity problem)?
|
Was the ptolemaic model geo- or heliocentric
: Was the Ptolemaic model geo- or heliocentric? Explain. How did Ptolemy and others before him account for retrograde motion (epicycle and deferent)? What is the most basic explanation for why this complicated theory could not possibly be correct?
|
|
What is the principal balance on the loan
: You take out a 30-year $450,000 mortgage loan with an APR of 7.75 percent and monthly payments. In 16 years you decide to sell your house and payoff the mortgage. What is your monthly payment? What is the principal balance on the loan? What is your t..
|
|
Global perspective-ethical dilemma
: Review the posting from the guest speaker Thomas Preston, who was a former Imaging Chemicals Global Commodity Manager for Eastman Kodak Company. Pay attention to the details regarding operations management and manufacturing in this real life case s..
|
|
Calculate operating cash flow for the year
: The owner of a bicycle repair shop forecasts revenues of $240,000 a year. Variable costs will be $70,000, and rental costs for the shop are $50,000 a year. Depreciation on the repair tools will be $30,000. The tax rate is 30%. Calculate operating cas..
|
|
What will be the annual impact on profit of obtaining
: Abruzzi sells its oil for $25 per gallon. The variable cost per gallon is $10.What will be the annual impact on profit of obtaining the Consolidated business (assuming there is no capacity problem)?
|
|
Description of the organization
: Milestone One: Problem Identification, Select an organization in which you are, were, or hope to be employed. Include in the paper the following: Paper title and Description of the organization
|
|
The cost of equity for a firm with a debt-equity ratio
: The cost of equity for a firm with a debt-equity ratio of .35:
|
|
What is the terminal value of the firms cash flows
: River Walk Tours is expected to have an EBIT of $354,000 next year. Depreciation, the increase in net working capital, and capital spending are expected to be $24,000, $2,000, and $33,000, respectively. What is the terminal value of the firm’s cash f..
|
|
Binomial model and no-arbitrage argument
: A stock price is currently $50. It is knows that at the end of six month, it will be either $55 or $35. The risk-free rate of interest with continuous compounding is 6% per annum. Calculate the value of a three-month European call option on the stock..
|