Question

In: Accounting

Exercise 6-1 Sheffield Sports sells volleyball kits that it purchases from a sports equipment distributor. The...

Exercise 6-1 Sheffield Sports sells volleyball kits that it purchases from a sports equipment distributor. The following static budget based on sales of 2,000 kits was prepared for the year. Fixed operating expenses account for 80% of total operating expenses at this level of sales. Sales Revenue $ 100,280 Cost of goods sold (all variable) 60,100 Gross margin 40,180 Operating expenses 35,170 Operating income $ 5,010 Prepare a flexible budget based on sales of 1,494, 2,690, and 3,870 units. (Round unit values to 2 decimal places e.g. 15.25 and all other answers to 0 decimal places, e.g. 145. If operating income is negative, enter amounts using a negative sign preceding the number e.g. -45 or parentheses e.g. (45).)

Solutions

Expert Solution

  • All working forms part of the answer
  • Amounts are in $
  • Under Flexible budget, it is to e noted that Variable cost changes as the unit changes, while fuxed cost remains the same. Hence, first variable cost per unit and fixed cost is to be calculated.

Units (A)

Amount (B) -$

per unit (B/A) - $

Sales

2000

100280

$50.14

(-) Cost of Goods Sold

2000

60100

$30.05

Gross Margin

2000

$40180

$20.09

(-) variable operating expense

2000

7034

$3.517

(-) fixed operating expenses

28136

Operating Income

$5010

  • Preparation of Flexile Budget

Units

1494

2690

3870

Sales

74909

134877

194042

(-) Cost of Goods Sold

44895

80835

116294

Gross margin

30014

54042

77748

(-) variable operating expense

5254

9461

13611

(-) fixed operating expenses

28136

28136

28136

Operating Income

$ -3376

$16445

$36002


Related Solutions

Vaughn Sports sells volleyball kits that it purchases from a sports equipment distributor. The following static...
Vaughn Sports sells volleyball kits that it purchases from a sports equipment distributor. The following static budget based on sales of 2,000 kits was prepared for the year. Fixed operating expenses account for 80% of total operating expenses at this level of sales. Sales Revenue $ 100,280 Cost of goods sold (all variable) 60,000 Gross margin 40,280 Operating expenses 35,170 Operating income $ 5,110 Prepare a flexible budget based on sales of 1,467, 2,570, and 3,840 units.
Bonita Sports sells volleyball kits that it purchases from a sports equipment distributor. The following static...
Bonita Sports sells volleyball kits that it purchases from a sports equipment distributor. The following static budget based on sales of 800 kits was prepared for the year. Fixed operating expenses account for 32% of total operating expenses at this level of sales. Sales $ 40,000 Cost of goods sold (all variable) 24,000 Gross margin 16,000 Operating expenses 14,000 Operating income $ 2,000 Assume that Bonita Sports actually sold 840 volleyball kits during the year at a price of $49...
King Sports owned by Tim Lane, sells sports equipment to schools and sporting clubs in Victoria....
King Sports owned by Tim Lane, sells sports equipment to schools and sporting clubs in Victoria. The following balances were reported in the Balance Sheet as at 30 June 2019. Account Name Balance ($) Cash at bank 39 400 Accounts receivable 2 800 Accounts payable 1 200 Capital – Tim Lane 41 000 (Note this question continues over the page) 4 Week 8 – Question 3 (Cont’d) Transactions for July 2019 were as follows: July 2 Received $2800 from accounts...
King Sports owned by Tim Lane, sells sports equipment to schools and sporting clubs in Victoria....
King Sports owned by Tim Lane, sells sports equipment to schools and sporting clubs in Victoria. The following balances were reported in the Balance Sheet as at 30 June 2019; Account Name Balance ($) Cash at bank 39 400 Accounts receivable 2 800 Accounts payable 1 200 Capital – Tim Lane 41 000 July transactions for 2019 were as follows: July 2 Received $2800 from accounts receivable 3 Paid $1000 of accounts payable 4 Paid rent for July $700 5...
Exercise 6-11 (Algo) Segmented Income Statement [LO6-4] Wingate Company, a wholesale distributor of electronic equipment, has...
Exercise 6-11 (Algo) Segmented Income Statement [LO6-4] Wingate Company, a wholesale distributor of electronic equipment, has been experiencing losses for some time, as shown by its most recent monthly contribution format income statement: Sales $ 1,587,000 Variable expenses 609,370 Contribution margin 977,630 Fixed expenses 1,075,000 Net operating income (loss) $ (97,370) In an effort to resolve the problem, the company would like to prepare an income statement segmented by division. Accordingly, the Accounting Department has developed the following information: Division...
Exercise 6-11 Segmented Income Statement [LO6-4] Wingate Company, a wholesale distributor of electronic equipment, has been...
Exercise 6-11 Segmented Income Statement [LO6-4] Wingate Company, a wholesale distributor of electronic equipment, has been experiencing losses for some time, as shown by its most recent monthly contribution format income statement: Sales $ 1,477,000 Variable expenses 576,990 Contribution margin 900,010 Fixed expenses 990,000 Net operating income (loss) $ (89,990) In an effort to resolve the problem, the company would like to prepare an income statement segmented by division. Accordingly, the Accounting Department has developed the following information: Division East...
Exercise 6-11 (Algo) Segmented Income Statement [LO6-4] Wingate Company, a wholesale distributor of electronic equipment, has...
Exercise 6-11 (Algo) Segmented Income Statement [LO6-4] Wingate Company, a wholesale distributor of electronic equipment, has been experiencing losses for some time, as shown by its most recent monthly contribution format income statement: Sales $ 1,642,000 Variable expenses 668,840 Contribution margin 973,160 Fixed expenses 1,070,000 Net operating income (loss) $ (96,840) In an effort to resolve the problem, the company would like to prepare an income statement segmented by division. Accordingly, the Accounting Department has developed the following information: Division...
Exercise 6-11 (Algo) Segmented Income Statement [LO6-4] Wingate Company, a wholesale distributor of electronic equipment, has...
Exercise 6-11 (Algo) Segmented Income Statement [LO6-4] Wingate Company, a wholesale distributor of electronic equipment, has been experiencing losses for some time, as shown by its most recent monthly contribution format income statement: Sales $ 1,643,000 Variable expenses 582,290 Contribution margin 1,060,710 Fixed expenses 1,167,000 Net operating income (loss) $ (106,290) In an effort to resolve the problem, the company would like to prepare an income statement segmented by division. Accordingly, the Accounting Department has developed the following information: Division...
Exercise 6-11 Segmented Income Statement [LO6-4] Wingate Company, a wholesale distributor of electronic equipment, has been...
Exercise 6-11 Segmented Income Statement [LO6-4] Wingate Company, a wholesale distributor of electronic equipment, has been experiencing losses for some time, as shown by its most recent monthly contribution format income statement: Sales $ 1,637,000 Variable expenses 668,110 Contribution margin 968,890 Fixed expenses 1,066,000 Net operating income (loss) $ (97,110) In an effort to resolve the problem, the company would like to prepare an income statement segmented by division. Accordingly, the Accounting Department has developed the following information: Division East...
Exercise 6-11 Segmented Income Statement [LO6-4] Wingate Company, a wholesale distributor of electronic equipment, has been...
Exercise 6-11 Segmented Income Statement [LO6-4] Wingate Company, a wholesale distributor of electronic equipment, has been experiencing losses for some time, as shown by its most recent monthly contribution format income statement: Sales $ 1,600,000 Variable expenses 641,400 Contribution margin 958,600 Fixed expenses 1,054,000 Net operating income (loss) $ (95,400) In an effort to resolve the problem, the company would like to prepare an income statement segmented by division. Accordingly, the Accounting Department has developed the following information: Division East...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT