Question

In: Accounting

Preparation of an Income Statement for The Serious Reader Company The first case of this course...

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.

Solutions

Expert Solution

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

Related Solutions

The trail balance will be used in preparation of the income statement, statement of owner's equity,...
The trail balance will be used in preparation of the income statement, statement of owner's equity, balance sheet, and statement of cash flow. Specifically how?
The first company: preparing the income statement in the short way to the company, and the...
The first company: preparing the income statement in the short way to the company, and the data is below? Here is the information for Al-Rafidain Company, which is required to prepare the short-term income statement: 400,000 net sales, 300,000 dividend income, 150,000 rental income, 75,000 consulting revenue, 100,000 cost of goods sold, 35,000 marketing expenses, 30,000 selling expenses, 20,000 administrative expenses, 10,000 maintenance expenses, 10,000 tax expenses
FINANCIAL STATEMENT PREPARATION - FINAL The following events occurred at MGR Company during its first year...
FINANCIAL STATEMENT PREPARATION - FINAL The following events occurred at MGR Company during its first year of business: a. To establish the MGR, Merry and Mary each contributed a total of $50,000 in exchange for common stock. b. MGR, or MerryGoRound is an Event Planning Company that specializes in high-end parties. The first year they conducted 94 events and revenue for the first year amounted to $470,000, of which 95% was to be paid by the date of the event...
Problem 1. Balance sheet and statement of cash flows preparation A. Prepare an income statement (multiple...
Problem 1. Balance sheet and statement of cash flows preparation A. Prepare an income statement (multiple step), balance sheet and cash flow statement using the selected financial statement information and additional data for Stanislaus Co. presented below. Balance sheet:                                                  December 31 2015 Cash..........................................................     $52,000                                                Accounts receivable (net)...........................       64,000                                                Inventory..................................................     178,000                                                Land..........................................................       78,800                                                Equipment.................................................     504,000                                                    TOTAL............................................ $876,800                                                Accumulated depreciation..........................     $94,000                                                Accounts payable.......................................       50,400                                                Notes payable - short-term........................       67,200                                                Notes payable -...
An instructor for a test preparation course claims that the course will improve the test scores...
An instructor for a test preparation course claims that the course will improve the test scores of students. The table shows the critical reading scores for 14 students the first two times they took the test. Before taking the test for the second​ time, the students took the​ instructor's course to try to improve their critical reading test scores. At a​ = 0.01, is there enough evidence to support the​ instructor's claim? Complete parts​ (a) through​ (f). number of students:14....
Question 2: Preparation and Presentation of the Income Statement SHOW YOUR WORKING FOR EACH OF THE...
Question 2: Preparation and Presentation of the Income Statement SHOW YOUR WORKING FOR EACH OF THE NUMBERED QUESTIONS In your new position as chief financial officer for Gulf Barges Limited, the first task you have been assigned to complete is to prepare the income statement for the 12-month period ended June 30, 2022. On your desk on your first day, the previous chief financial officer has left you valuable information to complete the task. SHOW YOUR WORKING FOR EACH OF...
QUESTION 2 A. State 20 items that goes into the preparation of income statement and balance...
QUESTION 2 A. State 20 items that goes into the preparation of income statement and balance sheet B. Differentiate between fixed and valuable cost, support your answer with examples. C. Distinguish between the following and support your answer with examples: i. Current and long-term assets ii. Current and long-term liabilities
E5.16   (Preparation of Partial Statement of Cash Flows—Operating Activities) (LO 8, 9) The statement of income...
E5.16   (Preparation of Partial Statement of Cash Flows—Operating Activities) (LO 8, 9) The statement of income of Kneale Transport Inc. for the year ended December 31, 2020, reported the following condensed information: Kneale Transport Inc. Year Ended December 31, 2020 Statement of Income Service revenue $545,000 Operating expenses  370,000 Income from operations 175,000 Other revenues and expenses Gain on disposal of equipment $25,000 Interest expense  10,000   15,000 Income before income tax 190,000 Income tax   42,000 Net income $148,000 Kneale's statement...
Develop an income statement in good form for Sanford Company for the first three months of...
Develop an income statement in good form for Sanford Company for the first three months of 20x3. Sanford Company The Sanford Company had the following balance sheet as of December 31, 20x2. The transactions for the first three months of 20x3 are also presented along with other information about specific accounts. Sanford Company Balance Sheet December 31, 20x2 ASSETS LIABILITIES Cash $ 57,000 Accounts Payable $ 34,000 Marketable Securities 8,000 Wages Payable 11,500 Accounts Receivable 73,000 Taxes Payable 8,000 Uncollectible...
An income statement for the first year of operations for Patti Company appears below: Sales $...
An income statement for the first year of operations for Patti Company appears below: Sales $ 390,000 Dividend revenue 39,000 Interest revenue 24,050 Cost of goods sold (208,000 ) Salary expense (26,000 ) Depreciation expense (70,200 ) Income tax expense (109,200 ) Net income $ 39,650 Additional information: Accounts payable, end of year, $13,000. Salaries payable, end of year, $8,450. Inventories, end of year, $26,000. Accounts receivable, end of year, $32,500. Required: Use the direct approach to calculate the cash...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT