Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Greenwork Accessories assembles a computer networking device from kits of imported components. You have been asked to develop a quarterly and annual operating budget and

Greenwork Accessories assembles a computer networking device from kits of imported components. You have been asked to develop a quarterly and annual operating budget and pro- forma income statements for 2016. You have obtained the following information: 20 points

Beginning-of-year balances

Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

$40,000.00

Accounts receivable (previous quarters sales) . . . . . . . . . . .

$15,000.00

Raw materials . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

300 kits

Finished goods . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

400 units

Accounts payable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

$40,000.00

Borrowed funds . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

$10,000.00

Desired end-of-year inventory balances

Raw materials . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

500 kits

Finished goods . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

200 units

Desired end-of-quarter balances

Standard cost per unit

Raw materials. . . . . . . . . . . . . . . . . . . . . . . . . .

Units

1 kit

Unit price

$40.00

Total

$40.00

Direct labor hours at rate. . . . . . . . . . . . . . . . . . . . . . . . . . .

0.8 hour

$20.00

16.00

Variable overhead/labor hour . . . . . . . . . . . . . . . . . . . . . . .

0.8 hour

$10.00

8.00

Total standard variable cost . . . . . . . . . . . . . . . . . . . . . . .

$64.00

Fixed cost per quarter

Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $40,000.00

Depreciation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10,000.00

Total . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $50,000.00

Selling and administrative costs

Variable cost per unit. . . . . . . . . . . . . . . . . . . . . . .. . . . . . .

Fixed costs per quarter:

$6.00

Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $20,000.00

Depreciation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5,000.00

Total . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $25,000.00

Interest rate per quarter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

0.04

Portion of sales collected

Quarter of sale . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

0.75

Subsequent quarter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

0.24

Bad debts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

0.01

Portion of purchases paid

Quarter of purchase. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

0.7

Subsequent quarter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

0.3

Unit selling price . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

$115.00

Sales Forecast

Quarter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . First Second Third Fourth

Unit sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2,400 1,500 2,000 3,100

Additional information

All cash payments except purchases are made quarterly as incurred.

All borrowings occur at the start of the quarter.

All repayments on borrowings occur at the end of the quarter.

All interest on borrowed funds is paid at the end of each quarter.

Borrowings and repayments may be made in any amount.

Required 20 points

A sales budget for each quarter and the year.

A production budget for each quarter and the year.

c. A purchases budget for each quarter and the year.

d. A manufacturing cost budget for each quarter and the year.

e. A selling and administrative expense budget for each quarter and the year.

f. A cash budget for each quarter and the year.

g. A pro-forma contribution income statement for each quarter and the year.

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

Accounting Theory

Authors: Ahmed Raihi-Belkaoui

5th Edition

1844800296, 978-1844800292

More Books

Students explore these related Accounting questions