Can you help me solve the problem

The Thai Corporation produces the tall fan A and the fat fan B. It has just finished the fiscal year in December, and now it is projecting the Income Statement and Balance Sheet for the next 3 months.

-The expected sales of A in the next 3 months: 300 units with the price of $15 per unit. While B: 360 units with the price of $12 per unit

-The sales in the last December is $3,000

-The total projected sales in next 3 months are allocated in each month as below: 10% in January, 30% in February, and 60% in March

-From the previous data, 40% of sales is collected in the same month, 60% in the following month

-There are currently 25 A and 45 B in the store. The cost of each A is $9, and 7$ for each B.

-At the end of the next three months, the required quantity of A and B is the same as the current inventory

-The total expected production cost of A is 11$, and B is 8$, under here is the proportion of the cost:

A

B

Material

50%

50%

Labor

30%

30%

Overhead

20%

20%

-The material cost is paid out totally in the next month

-The material cost in December is $350

-The labor cost and overhead cost are settled in the same month

-The cost of goods sold is based on the accounting FiFo

-The firm will purchase the new equipment with $5,000 in March

-The cash balance at the end of December is $500

-The required ending cash balance each month is $5000

-The other expenses estimatedin the whole 3 monthsas below:

General and Administration expenses

$1,500

Interest expense

$1,200

Dividend

$0

-General and Administration expenses are allocated equally in each month

-Interest, tax and dividend are paid out at the end of January

-The Marketable Securities, long-term Debt and Common Stock are assumedto be unchanged in the next 3 months

-Balance sheet at the end of December:

ASSETS

1. Cash .........................................................................................$500..........

2. Marketable Securities....................................................................$300.........

3. Accounts Receivable.....................................................................$1,800...........

4. Inventory .................................................................................$540..........

Total Current Assets........................................................................$3,140...........

6. Plant and Equipment ...................................................................$2.660...........

Total Assets...................................................................................$6,000...........

LIABILITIES AND STOCKHOLDERS' EQUITY

1. Account Payable .......................................................................$350............

2. Notes Payable ..........................................................................$0.............

3. Long-term Debt ........................................................................$500............

4. Common Stock .........................................................................$700..............

5. Retained Earning .......................................................................$4,450............

Total Liabilities and Stockholders' Equity.............................................$6,000............

1.Basing on the relevant information, please filling out the following tables

-Expected A and B sales for 3 months

A

B

Total

Quantity

Sales price

Sales revenue

$

$

$

-Beginning inventory

A

B

Total

Quantity

Cost

Total value

$

$

$

-The total production cost

A

B

Total

Projected unit sales

Desire ending inventory unit

Beginning inventory unit

Unit to be produced

Cost per unit produced

Total Production cost

$

$

$

-The cost of good sold

A

B

Combined

Beginning inventory

$

$

New inventory

$

$

Total cost of goods sold

$

$

$

-Pro Forma Income Statement of March 31

Sales revenue ....................................................................................$......................

Cost of goods sold .............................................................................$......................

Gross profit .....................................................................................$.....................

General and Administration expense .......................................................$.....................

EBIT ............................................................................................$......................

Interest expense ...............................................................................$......................

Earning before tax (EBT) ....................................................................$......................

Taxes (15%) ...................................................................................$......................

Earning after tax (EAT) .....................................................................$.......................

Common stock dividends ...................................................................$.......................

Increase in Retained Earnings ...............................................................$.......................

-Cash receipt (0.5 mark)

December

January

February

March

April

May

June

Sales

$

$

$

$

$

$

$

Collection from 40% current sales

$

$

$

$

$

$

Collection from 60% sales of the previous month

$

$

$

$

$

$

Total cash receipts

$

$

$

$

$

$

-Cash payment for the cost of material, labor, and overhead (0.5 mark)

A

B

Total production cost of 3 months

Average monthly cost

Unit produced

Cost per unit

Total Cost

Unit produced

Cost per unit

Total Cost

Materials

$

$

$

$

Labor

$

$

$

$

Overhead

$

$

$

$

-Cash payment

December

January

February

March

Monthly material purchase

$

$

$

$

Payment for material (prior month's purchase)

$

$

$

Monthly labor cost

$

$

$

Monthly overhead

$

$

$

General and Administrative expense

$

$

$

Interest expense

$

$

$

Taxes

$

$

$

Cash dividend

$

$

$

New equipment purchases

$

$

$

Total cashpayments

$

$

$

-Cash Budget

January

February

March

Total cash receipts

$

$

$

Total cash payments

$

$

$

Net cash flow

$

$

$

Beginning cash balance

$

$

$

Cumulative cash balance

$

$

$

Monthly loan (or repayment)

$

$

$

Cumulative loan balance

$

$

$

Ending cash balance

$

$

$

-Ending Inventory

Beginning Inventory ............................................................................$......................

Total production cost............................................................................$......................

Total inventory available for sales ............................................................$......................

Cost of goods sold ..............................................................................$.......................

Ending Inventory ...............................................................................$.......................

-Pro Forma Balance Sheet of March 31

ASSETS

1. Cash .........................................................................................$.....................

2. Marketable Securities....................................................................$.....................

3. Accounts Receivable.....................................................................$.....................

4. Inventory .................................................................................$.....................

5. Plant and Equipment ...................................................................$.....................

Total Assets...................................................................................$......................

LIABILITIES AND STOCKHOLDERS' EQUITY

1. Account Payable .......................................................................$.....................

2. Notes Payable ..........................................................................$.....................

3. Long-term Debt ........................................................................$.....................

4. Common Stock .........................................................................$.....................

5. Retained Earning .......................................................................$.....................

Total Liabilities and Stockholders' Equity.............................................$.......................