Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Electric Monkey Computer 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 next year. You have obtained the following information:
Beginning-of-year balances
Cash $75,000
Accounts receivable (previous quarters sales) $245,000
Raw materials 950 kits
Finished goods 1,500 kits
Accounts payable (materials) $125,000
Borrowed funds $30,000
Desired end-of-year inventory balances
Raw materials 1,000 kits
Finished goods 1,600 kits
Desired end-of-quarter balances
Cash $30,000
Raw materials as a portion of the following quarters production 0.20
Finished goods as a portion of the following quarters sales 0.30
Manufacturing costs
Standard cost per unit Units Unit price Total
Direct labor hours at rate 0.50 hour $30.00 $15.00
Raw materials 1 kit $75.0075.00
Variable overhead/labor hour 0.50 hour $5.002.50
Total standard variable cost $92.50
Fixed cost per quarter
Cash $110,000
Depreciation 15,000
Total $125,000
Selling and administrative costs $8.00
Variable cost per unit
Fixed costs per quarter
Cash $150,000
Depreciation 7,500
Total $157,500
Interest rate per quarter 0.015
Portion of sales collected
Quarter of sale 0.70
Subsequent quarter 0.29
Bad debts 0.01
Portion of purchases paid
Quarter of purchase 0.60
Subsequent quarter 0.40
Unit selling price $225
Sales forecast
Quarter First Second Third Fourth
Unit sales 4,4004,6004,5004,800
Additional information
All cash payments except purchases are made quarterly as incurred.
All borrowings occur at the start of a quarter.
All repayments on borrowings occur at the end of a quarter.
At the time the principal is repaid, interest is paid on the portion of principal that is repaid.
Borrowings and repayments may be made in any amount
Required
Note: Do not use negative signs with any of your answers in the requirements that follow.
Part A
Part B
Part C
Part D
Part E
Part F
Part G
d. A manufacturing cost budget for each quarter and the year.
Electric Monkey Computer Accessories
Manufacturing Cost Budget
For the Year Ending December 31
First Second Third Fourth Total
Production requirements:
Manufacturing resource requirements:
Direct materials
Direct labor hours
Variable manufacturing costs:
Direct materials
Direct labor
Manufacturing overhead
Total variable costs
Fixed manufacturing costs
Total manufacturing costs

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

Step: 3

blur-text-image

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

Financial Accounting

Authors: Jane L. Reimers

1st Edition

0131492012, 978-0131492011

More Books

Students also viewed these Accounting questions

Question

Describe the three major subdivisions of the Malleus Maleficarum.

Answered: 1 week ago

Question

Be able to differentiate between arbitration and mediation

Answered: 1 week ago

Question

Understand how arbitrators are credentialed and selected

Answered: 1 week ago

Question

Appreciate the advantages of arbitration

Answered: 1 week ago