help me to do the budgeted income statement (in jan.feb,march) not broken down i

Question

help me to do the budgeted income statement (in jan.feb,march) not broken down into 3, schedule of collection in sales( month 1-3),schedule of payment of manufactory cost (month 1-3) and cash budget (month 1-3)

Please show work

Vettel Manufacturing

For the Quarter Ending March 31, 2017

Vettel Manufacturing

Production Budget

For the Quarter Ending March 31, 2017

Required Production Units

Pounds of DM per Unit

Total DM Required for Production

DM Purchases (75% of current mon)

(25% of next mon

Total DM Purchases

==========================================

Direct Labor Hours Required Per Unit

==========================================

Fixed Selling and Administrative Expenses:

Supervisor Salaries

Factory Insurance

Depreciation of Factory Equipment

Total Factory Overhead Cost

Variable factory overhead

Total Factory Overhead Cost

1) Sales Budget 2) Production Budget 3) Direct Materials Purchases Budget 4) Direct Labour Cost Budget 5) Factory Overhead Cost Budget 6) Selling and Administrative Expenses Budget 7) Budgeted Income Statement 8) Schedule of Collections from Sales 9) Schedule of Payments for Manufacturing Costs 10) Cash Budget All budgets should be for the individual three (3) months of the first quarter of 2017. Include a quarterly total column on the right side. (except for #7 and #10) Each budget/requirement should be in a separate tab within one spreadsheet. All pages should be in portrait format using the same font type and size. Please staple the printed copy in the upper left corner.

Explanation / Answer

1. Sales

2016 Actual Sales

2017 Estimated Sales

Nov

Dec

Jan

Feb

Mar

Apr

May

Units ( SP UNIT price$ 68.99)

7,835

7,970

7,450

7,090

8,320

9,070

10,120

CASH SALE

392

400

373

355

416

454

CREDIT SALE

5583

5678

5307

1770

5928

1860

1892

5052

1683

1976

7538

7199

6822

POUNDS

JAN

FEB

MAR

OP STOCK

5213

1773

2080

PURCHSES

4010

7397

8508

CL STOCK

*1773

#2080

@2268

= PRODUCTION

7450

7090

8320

+ to keep

# 8320 x 25%

@9070 x 25%

PURCHSES

units

4010

7397

8508

X 2.83

X 2,83

X 2,83

X$1.38

X$1.38

X$1.38

=

$ 15661

28888

33227

PAYMENTS

DEC   $5755

FEB 80%

$23110

MAR 80%

$26582

JAN X 80%=

$ 12529

JAN X 20%= 3132

FEB 20%

5778

18284

26242

32360

DIRECT LABOUR

PRODUCTION

7450

7090

8320

X1.75 HOURS

X1.75 HOURS

X1.75 HOURS

X $12.25

X $12.25

X $12.25

$159709

$151991

$178360

FREIGHT

X .8 X

5960

5672

6656

CASH BUDGET

JAN

FEB

MAR

CASH INFLOWS

CASH SALES

373

355

416

CREDIT SALES

7538

7199

6822

7911

7554

7238

X 68.99

$545780

$521150

$499350

CASH OUTFLOWS

SUPPLIERS OF MATERIAL

18284

26242

32360

DIRECT LABOUR

159709

151991

178360

FRIEGHT

5960

5672

6656

SALES COMMISSION

5458

5212

4994

FACTORY FIXED OHDS

66500

66500

66500

COMPUTER

180000

FIXED S & d EXPENSES

10900

10900

10900

LOAN REPAYMENT

300000

446811

266517

599770

NET IN/ (OUT)

98969

254633

(100420)

CASH B/F

CASH C/F

1. Sales

2016 Actual Sales

2017 Estimated Sales

Nov

Dec

Jan

Feb

Mar

Apr

May

Units ( SP UNIT price$ 68.99)

7,835

7,970

7,450

7,090

8,320

9,070

10,120

CASH SALE

392

400

373

355

416

454

CREDIT SALE

5583

5678

5307

1770

5928

1860

1892

5052

1683

1976

7538

7199

6822

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.