Parte 2

Realice los presupuestos segn discutidos en clase

40 Puntos

Month

December sales $ 1,500 with an increase of $ 100 monthly.

Other Data:

1- The Cost of Good Sold is 55% of sales

2- Monthly fixed costs are $175 plus $45 of depreciation expenses

3- The company maintains inventory at two-month supply.

4- The company pays for its purchases 57% in the month of purchase and 43% in the following month

5- The company collects 69% of its sales in the month of sale, 31% in the following month.

6- The company pays all other expenses requiring cash disbursements as incurred

7- The company tries to keep at least $ 70 cash as buffer against unexpected cash needs.

8- The purchase for december is $ 605

Balance Sheet at December 31, 2020

Assets

Equity

Cash

450

Accounts Payable

1,050

Accounts Receivable

500

Inventory

1,300

Fixed assets, net

2,300

Stockholder's Equity

3,500

Total

4,550

Total

4,550

Exhibit # 1

Budgeted Income Statements

January

February

March

April

May

June

Total

Sales

CGS

Gross profit and

contribution margin

Fixed costs

Income

Exhibit # 2

Purchases Budget

January

February

March

April

May

June

Total

CGS

Budgetered ending

inventory

Total Requestment

Beginning Inventory

Purchase

Exhibit # 3

Cash Receipts Budget

January

February

March

April

May

June

Total

Sales for the Month

Collections:

From prior month,____%

From current month,____%

Total Receipts

Exhibit # 4

Cash Disbursement for Purchases

January

February

March

April

May

June

Total

From prior month,____%

From current month,____%

Total

Exhibit # 5

Cash Disbursement Budget

January

February

March

April

May

June

Total

For Merchandise

Fixed costs requiring cash

Total

Exhibit # 6

Cash Budget

January

February

March

April

May

June

Total

Beginning Balance

Cash Receipt

Total Available

Cash Disbursements

Indicated Balance

Excess ( defficiency )

Borrow

Repay

Ending Balance