In: Accounting
Preparation of an Income Statement for The Serious Reader Company
The first case of this course provides an opportunity to prepare a segmented variable costing (contribution margin, behavioral) income statement and analyze the information. This is a very small company and the information may seem simplistic at first glance. Don’t forget that numbers and hands-on practice best illustrate many basic accounting concepts.
The Serious Reader Company is a small online retailer operating out of a garage apartment. The owner buys books at garage sales, thrift shops, library sales, and whenever an opportunity arises. The company classifies all books into five categories based on cost of acquisition and estimated sales price. See below for details about books purchased and sold during the last year (20XX).
Price Categories | |||||
A | B | C | D | E | |
Units Sold | 4,000 | 1,000 | 500 | 400 | 400 |
Unites Purchased | 6,000 | 1,200 | 1,000 | 1,000 | 1,000 |
Resale Price | $4.00 | $12.00 | $20.00 | $45.00 | $60.00 |
Cost | $0.50 | $4.00 | $10.00 | $20.00 | $20.00 |
In addition to purchasing inventory (used books), the company incurs some operating expenses.
Variable Operating Expenses | |
Shipping per book | $1.50 |
Common fixed expenses | |
Internet-related costs | $10,000 |
Travel, etc. | $4,000 |
Advertising | $1,000 |
Other overhead | $5,000 |
Case Assignment
Required:
Computations (use Excel)
Prepare a segmented variable costing (behavioral) income statement for the company in good format.
Prepare a second variable costing statement assuming 90% of all the books in each category purchased were actually sold.
Prepare a third variable costing statement assuming that the price is increased by 50% for all five categories (use original sales information).
The owner enjoys the used-book business. Any suggestions as how to turn this into a full-time business venture so the owner can quit his other job? Prepare another income statement to support your idea.
Memo (use Word)
Interpret the results from the computations and explain how the information is useful. Write a 4- or 5-paragraph memo to the owner of the business. Start with an introduction and end with a recommendation. Each of the four or five paragraphs should have a heading.
Short essay to comment on the questions below (use Word). Start with an introduction and end with a summary or conclusion. Use headings. Maximum length of two pages.
Why do many organizations make the effort to prepare a different type of income statement for internal purposes?
Variable costing is not just about preparing income statements. Provide at least three scenarios in which understanding how costs behave is useful.
Particulars | A | B | C | D | E | Total | |
1 | Units Sold F | 4000 | 1000 | 500 | 400 | 400 | |
Units Purchased G | 6000 | 1200 | 1000 | 1000 | 1000 | ||
Resale price H | $4 | 12 | 20 | 45 | 60 | ||
Cost I | $0.50 | 4 | 10 | 20 | 20 | ||
Shipping per book J | $1.50 | $1.50 | $1.50 | $1.50 | $1.50 | ||
Sales F*H | $16,000 | $12,000 | $10,000 | $18,000 | $24,000 | $80,000 | |
Purchases F*I | $2,000 | $4,000 | $5,000 | $8,000 | $8,000 | $27,000 | |
Shipping Cost J*F | $6,000 | $1,500 | $750 | $600 | $600 | $9,450 | |
Contribution | $8,000 | $6,500 | $4,250 | $9,400 | $15,400 | $43,550 | |
Less: Fixed Cost | |||||||
Internet Related Cost | $ 10,000 | ||||||
Travel | $ 4,000 | ||||||
Advertising | $ 1,000 | ||||||
Other Overhead | $ 5,000 | ||||||
Net Income | $23,550 | ||||||
90% of Goods purchased is sold | |||||||
2 | Particulars | A | B | C | D | E | Total |
Units Sold F | 5400 | 1080 | 900 | 900 | 900 | ||
Units Purchased G | 6000 | 1200 | 1000 | 1000 | 1000 | ||
Resale price H | $4.00 | $12.00 | $20.00 | $45.00 | $60.00 | ||
Cost I | $0.50 | $4.00 | $10.00 | $20.00 | $20.00 | ||
Shipping per book J | $1.50 | $1.50 | $1.50 | $1.50 | $1.50 | ||
Sales F*H | $21,600 | $12,960 | $18,000 | $40,500 | $54,000 | $147,060 | |
Purchases F*I | $2,700 | $4,320 | $9,000 | $18,000 | $18,000 | $52,020 | |
Shipping Cost J*F | $8,100 | $1,620 | $1,350 | $1,350 | $1,350 | $13,770 | |
Contribution | $10,800 | $7,020 | $7,650 | $21,150 | $34,650 | $81,270 | |
Less: Fixed Cost | |||||||
Internet Related Cost | $ 10,000 | ||||||
Travel | $ 4,000 | ||||||
Advertising | $ 1,000 | ||||||
Other Overhead | $ 5,000 | ||||||
Net Income | $61,270 | ||||||
Price increase by 50% it is resale price | |||||||
3 | Particular | A | B | C | D | E | Total |
Units Sold F | 4000 | 1000 | 500 | 400 | 400 | ||
Units Purchased G | 6000 | 1200 | 1000 | 1000 | 1000 | ||
Resale price H | $6 | $18 | $30 | $68 | $90 | ||
Cost I | $0.50 | $4.00 | $10.00 | $20.00 | $20.00 | ||
Shipping per book J | $1.50 | $1.50 | $1.50 | $1.50 | $1.50 | ||
Sales F*H | $24,000 | $18,000 | $15,000 | $27,000 | $36,000 | $120,000 | |
Purchases F*I | $2,000 | $4,000 | $5,000 | $8,000 | $8,000 | $27,000 | |
Shipping Cost J*F | $6,000 | $1,500 | $750 | $600 | $600 | $9,450 | |
Contribution | $16,000 | $12,500 | $9,250 | $18,400 | $27,400 | $83,550 | |
Less: Fixed Cost | |||||||
Internet Related Cost | $ 10,000 | ||||||
Travel | $ 4,000 | ||||||
Advertising | $ 1,000 | ||||||
Other Overhead | $ 5,000 | ||||||
Net Income | $63,550 | ||||||
The organization make different type of income statement so that they may know which combination can give them best results or highest net Income |