mba-560 unit 3 problem 5-33 and 6-25

unit_3_templates_p_5-33_and_p_6-25_1.xlsx5-33_part_1_of_2 5-33_part_2_of_2 6-25

mba-560 unit 1 problem 5-33 and 6-25

P05

–

33

Cost

@ =

@ =

Correct!

of Goods Sold and

Inventory

Cost Cost

– Cost

Units per Unit of Goods Sold

@ =

@ =

@ =

Correct!
Cost Ending

Units per Unit Inventory

From Second Purchase @

=

and Ending Inventory

Cost Cost

– Cost of Goods Sold

Units per Unit

From Second Purchase @ =

From First Purchase @
Total Units Sold

Correct! Correct!

Cost

Units per Unit Cost

From Beginning Inventory @ =

From First Purchase

Correct! Correct!

Total Total Cost
Cost Units per Unit

470 =

x: Hint: Use the round function on this to 3 places.

Correct! Correct!
Cost of Goods Sold @ =

@ 94.766 =

Correct! Correct!

CLEAR PHOTOGRAPHY, INC.

and

Weighted
FIFO LIFO Average

$ 55,500
x: Enter the appropriate data in the yellow cells. Your entries for “Net Income” will be verified. $ 55,500
x: Enter the appropriate data in the yellow cells. Your entries for “Net Income” will be verified.

Cost of Goods Sold

15,000 15,000

)

)

)
x: Hint: Use the rounddown function on this to 0 places.

Net Income

Correct! Correct! Correct!

CLEAR PHOTOGRAPHY, INC.

FIFO LIFO

Sales $ 55,500
x: Enter the appropriate data in the yellow cells. Your entries for “Net Income” will be verified. $ 55,500
x: Enter the appropriate data in the yellow cells. Your entries for “Net Income” will be verified. $ 55,500
x: Enter the appropriate data in the yellow cells. Your entries for “Net Income” will be verified.
Cost of Goods Sold
Gross Margin

Operating Expenses
Net Income Before Tax
Income Tax Expense

Net Income $ 7,776 $ 6,780 $ 7,242
Correct! Correct! Correct!

FIFO LIFO Weight. Av.

$ 15,000 $ 15,000

Correct!

For the Year Ended December 31, 2012

FIFO LIFO

$ 55,500
x: Enter the appropriate data in the yellow cells. Your entry for Cash Flow for each section will be verified.

$ 55,500
x: Enter the appropriate data in the yellow cells. Your entry for Cash Flow for each section will be verified.

x: Enter the appropriate data in the yellow cells. Your entries for “Net Income” will be verified.
x: Enter the appropriate data in the yellow cells. Your entries for “Net Income” will be verified.

x: Enter the appropriate data in the yellow cells. Your entries for “Net Income” will be verified.
x: Enter the appropriate data in the yellow cells. Your entries for “Net Income” will be verified.

31,040 31,040

15,000 15,000 15,000

5,184 4,520 4,828

– – –

Correct! Correct! Correct!

– – –

Correct! Correct! Correct!

18,000 18,000

Student Name:

Class:

Problem 05-33

Requirement a.

CLEAR PHOTOGRAPHY, INC.

Goods Available for Sale

Cost

Units

per Unit

Beginning

Inventory

150 x: Enter the appropriate data in the yellow cells. Your column totals will be verified.

@

$ 90

=

$ 13,500

First Purchase

Second Purchase

Total

470

$ 44,540

Correct!

Requirement a. (1) Save Time On Research and Writing Hire a Pro to Write You a 100% Plagiarism-Free Paper. Get My Paper

Cost

Ending

FIFO

of Goods Sold

From Beginning Inventory

From First Purchase

From Second Purchase

Total Units Sold

$ 27,540

FIFO – Ending Inventory

$ 100

Requirement a. (2)

Cost of Goods Sold

LIFO

of Goods sold

300

$ 29,

200

LIFO – Ending Inventory

Total Ending Inventory

170

$ 15,340

Requirement a. (3)

Weighted

Average

¸

$

94.766

Ending Inventory:

16,110 x: Hint: Use the rounddown function on this to 0 places.

Computation of

Income Tax Expense

Net Income

Sales

$ 55,500 x: Enter the appropriate data in the yellow cells. Your entries for “Net Income” will be verified.

Gross Margin

Operating Expenses

15,000

Net Income Before Tax

12,960

11,300

12,070

Income Tax (40%)

(

5,184

(

4,520

(

4,828

$ 7,776

$ 6,780

$ 7,242

Requirement b.

Financial Statements

Income Statements

For the Year Ended December 31, 2012

Weight. Av.

Balance Sheets

As of December 31, 2012

Assets

Cash

Merchandise Inventory

Total Assets

Stockholders’ Equity

Common Stock

$ 15,000

Retained Earnings

24,276

23,280

23,742

Total Stockholders’ Equity

$ 39,276

Statement of Cash Flows

Weight Av.

Cash Flows From Operating Activities:

Cash Inflow from Customers

$ 55,500 x: Enter the appropriate data in the yellow cells. Your entry for Cash Flow for each section will be verified.

x: Enter the appropriate data in the yellow cells. Your column totals will be verified.

x: Enter the appropriate data in the yellow cells. Your entries for “Net Income” will be verified.

x: Hint: Use the round function on this to 3 places.

x: Hint: Use the rounddown function on this to 0 places.

Cash Outflow for Inventory

31,040

Cash Outflow for Operating Expense

Cash Outflow for Income Tax

Net Cash Flow from Operating Activities

Cash Flows from Investing Activities

Cash Flows from Financing Activities

Net Change in Cash

Plus: Beginning Cash Balance

18,000

Ending Cash Balance

P06-25

Student Name:
Class:

200

Cost
Delivery Cost 200
Total Cost
Less: Salvage Value

2012 Depreciation

Correct!

2013 Depreciation

2012 Depreciation

2013 Depreciation

Correct!

Problem 06-25
O’BRIAN SERVICE COMPANY
Depreciation
Requirement a: Straight Line
	Cost
A satisfied Microsoft Office user: Enter the appropriate data in the yellow cells. Your entries for 2008 and 2009 Depreciation will be verified under each method.
	Delivery Cost
	Total Cost
	Less: Salvage Value
Depreciable Cost
Estimated Life
		2012 Depreciation
		2013 Depreciation
Requirement b: Units of Production
Estimated Units of Production
Cost per Unit
$ 4,600
Requirement c: Double Declining Balance
$ 4,300

P6-25

DDB

calc

DDB

P 6-25

2012: ($17,200 – 0) x (2 x .25)

2013: ($17,200 – 8,600) x (2 x .25)

Sheet2

Sheet3