Question

In: Accounting

PROBLEM 1 The owner of the Red Mill Inn reviews gift shop sales on a monthly...

PROBLEM 1
The owner of the Red Mill Inn reviews gift shop sales on a monthly basis. Over the years,
certain items have been dropped from the shop because their sales provided insufficient
profit relative to the other gift shop items. Information for the past six months on three gift
shop items is in the table below.
BAG OF SWEET STICKY
MUFFINS BREAD BUNS
Sales $2,160.00 $540.00 $2,880.00
Variable costs $1,170.00 $256.50 $1,260.00
Contribution Margin $990.00 $283.50 $1,620.00
Fixed costs $480.00 $350.00 $600.00
Net Income $510.00 ($66.50) $1,020.00

Question

25% of the fixed costs of each item are avoidable; the other 75% are not. Show calculations
to determine if Sweet Bread is profitable or not.

Solutions

Expert Solution

Total net income if sweet bread continue              1,464 See Note 1
Total net income if sweet bread discontinue              1,268 See Note 2
Loss of profit due to discontinuation                  196
Decision: Sweet Bread is profitable
Note 1: Income Statement If sweet Bread continue
BAG OF MUFFINS SWEET BREAD STICKY BUNS Total
Sales        2,160           540        2,880              5,580
Variable costs        1,170           257        1,260              2,687
Contribution Margin           990           284        1,620              2,894
Fixed costs           480           350           600              1,430
Net Income           510            (67)        1,020              1,464
Note 2: Income Statement If sweet Bread discontinue
BAG OF MUFFINS SWEET BREAD STICKY BUNS Total
Sales        2,160        2,880              5,040
Variable costs        1,170        1,260              2,430
Contribution Margin           990        1,620              2,610
Fixed costs           480           263           600              1,343
Net Income           510          (263)        1,020              1,268

Related Solutions

The Red Mill Inn is in need of a new roof. A local contractor, Jack Hammer,...
The Red Mill Inn is in need of a new roof. A local contractor, Jack Hammer, has been asked to submit a bid to do the work. Jack measured the roof and determined he would need 50 cases of roofing material. The cost per case is $45. Jack also determined it would take a four-man crew four 8-hour work days to complete the job. Each worker is paid $15 per hour. Before the year began, Jack estimated his total overhead...
Problem 1 The time it takes to process phone orders in a gift shop is normally...
Problem 1 The time it takes to process phone orders in a gift shop is normally distributed with a mean of 6 minutes and a variance of 4 minutes. a. what is the probability that a phone order can be processed by at least 5 minutes b. what is the probability that a phone order can be processed by at most 4 minutes c. What cutoff value would separate the 10% of orders that take the most time to process?...
Kate, the owner/operator of the Las Vegas Inn, is interested in determining the level of sales...
Kate, the owner/operator of the Las Vegas Inn, is interested in determining the level of sales necessary to realize a net income of $500,000 next year. She has complied records on each department’s sales and costs, and assumes that the sales mix will be the same next year. The major department, the rooms department, had sales of $2,500,000, and its contribution margin was $1,750,000. The coffee shop had sales of $750,000 and variable costs of $300,000. The restaurant had sales...
Problem 7.6A. Unmatched Elegance Gift Shop sells cards, supplies, and various holiday greeting cards. Sales to...
Problem 7.6A. Unmatched Elegance Gift Shop sells cards, supplies, and various holiday greeting cards. Sales to retail customers are subject to an 8 percent sales tax. The firm sells it merchandise for cash; to customers using bank credit cards, such as MasterCard and VISA; and to customers using American Express. The bank credit cards charge a 2 percent fee. American Express charges a 3 percent fee. Unmatched Elegance Gift Shop also grants trade discounts to certain wholesale customers who place...
Better Footprint Shop, a fair-trade environmentally friendly gift shop, purchases goods from developing countries. The owner...
Better Footprint Shop, a fair-trade environmentally friendly gift shop, purchases goods from developing countries. The owner of the shop, Paula Miranda, is thinking of adding a fundraising program which would encourage nonprofit organizations such as schools, churches and community groups to sell fair trade chocolates. The nonprofit organization would sell the candy bars for $3/candy bar and Better Footprint would give them a $1.25/candy bar sales discount. In other words, Better Footprint would collect $1.75/candy bar from the nonprofits. Better...
Problem 1: The Glen Stein Shop sells steins from all parts of the world. The owner...
Problem 1: The Glen Stein Shop sells steins from all parts of the world. The owner of the shop, John Glen, is thinking of expanding his operations by hiring local college students, on a commission basis, to sell steins at the local college. The steins will bear the school emblem. These steins must be ordered from the manufacturer three months in advance, and because of the unique emblem of each college, they cannot be returned. The steins would cost Mr....
Problem # 1 The monthly sales for Telco Batteries Inc. were as follows:                         Sales Month     &
Problem # 1 The monthly sales for Telco Batteries Inc. were as follows:                         Sales Month            (000 units) January            20 February          21 March              15 April                14 May                 13 June                 16 July                 17 August            18 September       20 October           20 November       21 December        23 Plot the monthly sales data. Forecast coming January sales using each of the following: The naïve approach A 6-month moving average A 6-month weighted average using 0.1, 0.1, 0.1, 0.2, 0.2 and 0.3, with the heaviest...
Amira, the owner of a music equipment shop wanted to have a sales budget for the...
Amira, the owner of a music equipment shop wanted to have a sales budget for the next three months. She asked her assistant Dina to do the job. After consulting with friends in the same business, Dina estimated February revenues to be $30,000. She expects revenues to increase by $3,000 per month in March and April. Dina also expects that 60% of sales to be cash and 40% of sales to be on credit. Sales on credit are expected to...
Kline Sisters Company operates a gift shop where peak sales and activity occur in the months...
Kline Sisters Company operates a gift shop where peak sales and activity occur in the months of December and January. Data regarding the store's operations follow: Sales are budgeted at $360,000 for January, 320,000 for February, and $250,000 for March and $240,000 in April. Collections are expected to be 30% in the month of sale, 65% in the month following the sale, 3% in the second month following sale and 2% uncollectible. The cost of goods sold is 76% of...
Kline Sisters Company operates a gift shop where peak sales and activity occur in the months...
Kline Sisters Company operates a gift shop where peak sales and activity occur in the months of December and January. Data regarding the store's operations follow: Sales are budgeted at $360,000 for January, 320,000 for February, and $250,000 for March and $240,000 in April. Collections are expected to be 30% in the month of sale, 65% in the month following the sale, 3% in the second month following sale and 2% uncollectible. The cost of goods sold is 76% of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT