Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Carter Company is a bookstore that prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of

Carter Company is a bookstore that prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master budget for the first quarter:

  1. As of December 31 (the end of the prior quarter), the companys general ledger showed the following account balances:

Debit Credit

Cash 48,000

Accounts Receivable 224,000

Inventory 60,000

Building & Equipment 370,000

(net of Accumulated Depr)

Accounts Payable 93,000

Capital shares 500,000

Retained Earnings 109,000

Totals $ 702,000 $ 702,000

  1. Actual sales for December and budgeted sales for the next four months are as follows;

December (actual) $ 280,000

January 400,000

February 600,000

March 300,000

April 200,000

  1. Sales are 20% for cash and 80% on credit. All payments on credit sales are collected in the month following sale. The accounts receivable at December 31st are a result of December credit sales.
  2. The companys gross margin is 40% of sales.
  3. Monthly expenses are budgeted as follows:

- salaries and wages $ 27,000 per month

- advertising $ 70,000 per month

- shipping costs are 5% of sales

- depreciation is $ 14,000 per month

- other expenses are 3% of sales

f. At the end of each month, inventory is to be on hand equal to 25% of the following months sales needs, stated at cost.

g. One-half of a months inventory purchases is paid for in the month of purchase; the other half is paid for in the following month.

h. During February, the company will purchase a new copy machine for $ 1,700 cash. During March, other equipment will be purchased for cash at a cost of $ 84,500.

i. During January, the company will declare and pay $ 45,000 in cash dividends.

j. The company must maintain a minimum cash balance of $ 30,000. An open line of credit is available at a local bank for any borrowing that may be needed during the quarter. All borrowing is done at the beginning of a month and all repayments are made at the end of a month. Borrowing and repayments of principal must be in multiples of $ 1,000. Interest is paid only at the time of repayment of principal. The annual interest rate is 12%. (Figure out interest on whole months, example, 1/12, 2/12, etc.)

1. Prepare an Income Statement

2. Prepare a balance sheet

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Accounting

Authors: Will Seal, Carsten Rohde, Ray Garrison, Eric Noreen

6th Edition

0077185536, 978-0077185534

More Books

Students also viewed these Accounting questions

Question

Find the indicated derivative. dy dx if y = 2x

Answered: 1 week ago

Question

Compare social roles with gender roles. Critical T hinking

Answered: 1 week ago

Question

=+ Who are the buyers/users of the products abroad?

Answered: 1 week ago