Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Example Inc. has just closed the books for the year ending December 31, 2014. Based on the information provided, answer the questions that follow. December

Example Inc. has just closed the books for the year ending December 31, 2014. Based on the information provided, answer the questions that follow.

December 31, 2014 Balance Sheet

ASSETS

LIABILITIES AND EQUITY

Cash

$36,000

Accounts Payable

$400,000

Accounts Receivable, net

990,000

Salary Payable

125,000

Inventories ***

0

Interest Payable

90,000

Finished Goods 290,000

Raw Materials 40,000

330,000

Bank Line (7%)

110,000

Current Assets

1,356,000

Current Liabilities

725,000

Term Debt (9%)

1,000,000

Fixed Assets, net of accumulated depreciation

1,542,600

Total Liabilities

1,725,000

Common Stock

210,000

Retained Earnings

963,600

Total Equity

1,173,600

Total Assets

$2,898,600

Total Liabilities & Equity

$2,898,600

*** Inventory Finished Goods represents 20,000 units of finished goods at a cost of $14.50 per unit, Raw materials for 5,000 units at $8.00 per units, Work-in process inventory is zero at December 31.

The company is now in the process of finishing its projections for the year 2015. Historical sales for the last quarter as well as sales projections for the next thirteen months are shown below:

Month

Units Sold and Sales Price

October, 2010

(50,000 units at $20.00 each)

November, 2010

(50,000 units at $20.00 each)

December, 2010

(50,000 units at $20.00 each)

January, 2015

(50,000 units at $25.00 each)

February

(60,000 units at $25.00 each)

March

(70,000 units at $25.00 each)

April

(80,000 units at $25.00 each)

May

(95,000 units at $25.00 each)

June

(100,000 units at $25.00 each)

July

(100,000 units at $25.00 each)

August

(100,000 units at $25.00 each)

September

(102,000 units at $25.00 each)

October

(105,000 units at $25.00 each)

November

(107,000 units at $25.00 each)

December

(110,000 units at $25.00 each)

Monthly sales 2016

(110,000 units at $30.00 each)

The company has had steady sales of 50,000 units per month for the past several years, but the factory has sufficient capacity to produce 150,000 units per month, without having to invest in significant additional fixed assets.

For forecasting purposes the company assumes 25% of sales are collected the month of the sale, 45% in the subsequent month, 27% in the second month after the sale and 3% uncollectible. The percent of sales method is used for allowance for Doubtful Accounts. Bad Debts are written off each quarter.

Desired ending finished goods inventory is 20% of next month

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_2

Step: 3

blur-text-image_3

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

Learning Sage 50 Accounting 2016 A Modular Approach

Authors: Harvey Freedman

17th Edition

0176768092, 9780176768096

More Books

Students also viewed these Accounting questions