Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 28, 2024

Sales Budget Quarter #1 Quarter #2 Quarter #3 Quarter #4 Total Sales in Units 2,250 2,900 1,750 1,750 8,650 Selling Price per Unit $48 $48

Sales Budget Quarter #1 Quarter #2 Quarter #3 Quarter #4 Total

Sales in Units 2,250 2,900 1,750 1,750 8,650

Selling Price per Unit $48 $48 $48 $48 $48

Sales Revenue $108,000 $139,200 $84,000 $84,000 $415,200

Expected Cash Collections Quarter #1 Quarter #2 Quarter #3 Quarter #4 Total

Accounts Receivable

Current month sales $59,400 $76,560 $46,200 $46,200 $228,360

Last month sales $48,600 $62,640 $37,800 $149,040

$59,400 $125,160 $108,840 $84,000 $377,400

Production Budget Quarter #1 Quarter #2 Quarter #3 Quarter #4 Total

Sales In Units 2,250 2,900 1,750 1,750 8,650

Add: Desired Ending Inventory 725 437.5 437.5 575 575

Total Needs 2,975 3,337.5 2,187.5 2,325 9,225

Less: Beginning Finished Goods Inventory 200 725 437.5 437.5 200

Units To Be Produced 2,775 2,612.5 1,750 1,887.5 9,025

Direct Materials Purchases Quarter #1 Quarter #2 Quarter #3 Quarter #4 Total Direct Materials Purchases Quarter #1 Quarter #2 Quarter #3 Quarter #4 Total

Units To Be Produced 2,775 2,612.5 1,750 1,887.5 9,025 Units To Be Produced 2,775 2,612.5 1,750 1,887.5 9,025

Materials Per Unit 5 5 5 5 5 Materials Per Unit 3 3 3 3 3

Production Needs 13875 13063 8750 9438 45125 Production Needs 8325 7838 5250 5663 27075

Add: Desired Ending Inventory 3918.75 2625 2831.25 3375 3375 Add: Desired Ending Inventory 2351.25 1575 1698.75 2025 2025

Total Needed 17794 15688 11581 12813 48500 Total Needed 10676 9413 6949 7688 29100

Less: Beginning Inventory 450 3918.75 2625 2831.25 450 Less: Beginning Inventory 0 2351.25 1575 1698.75 0

Materials To Be Purchased 17344 11769 8956 9981 48050 Materials To Be Purchased 10676 7061 5374 5989 29100

Materials Cost Per Ounce $0.75 $0.75 $0.75 $0.75 $0.75 Materials Cost Per Ounce $0.40 $0.40 $0.40 $0.40 $0.40

Total Materials Purchase Cost $13,007.81 $8,826.56 $6,717.19 $7,485.94 $36,037.50 Total Materials Purchase Cost $4,270.50 $2,824.50 $2,149.50 $2,395.50 $11,640

Cash Purchases Budget Quarter #1 Quarter #2 Quarter #3 Quarter #4 Total

Accounts Payable 3/31

Current Month Purchases $7,775.24 $5,242.98 $3,990.01 $4,446.65 $21,454.88

Last Month Purchases $9,503.07 $6,408.08 $4,876.68 $20,787.83

Total Cash Disbursements For Purchases $7,775.24 $14,746.05 $10,398.09 $9,323.33 $42,242.71

Direct Labor Budget Quarter #1 Quarter #2 Quarter #3 Quarter #4 Total

Units To Be Produced 2,775 2,612.5 1,750 1,887.5 9,025

DL Hours Needs Per Unit 0.8 0.8 0.8 0.8 0.8

DL Hours Needed 2,220 2,090 1,400 1,510 7,220

DL Cost Per Hour $18.75 $18.75 $18.75 $18.75 $18.75

Total Budgeted DL $41,625 $39,187.5 $26,250 $28,312.5 $135,375

Overhead Budget Quarter #1 Quarter #2 Quarter #3 Quarter #4 Total

DL hours needed 2,220 2,090 1,400 1,510 7,220

VOH rate / hour 2 2 2 2 2

Budgeted variable OH 4,440 4,180 2,800 3,020 14,440

Budgeted fixed MOH costs 8,500 8,500 8,500 8,500 34,000

Total budgeted OH expense 12,940 12,680 11,300 11,520 48,440

Less: Depreciation 1,750 1,750 1,750 1,750 7,000

Total cash disbursements for MOH 11,190 10,930 9,550 9,770 41,440

Ending Finished goods

Production costs per unit Quantity Cost Total

Direct materials

Direct labor

MOH

Budgeted finished goods inventory

Ending inventory, in units

Unit product cost

Ending finished goods inventory

Selling and Administrative Expense Budget Quarter #1 Quarter #2 Quarter #3 Quarter #4 Total

Budgeted sales

Variable S&A rate

Variable expenses

Fixed S&A

Total S&A

Less: Depreciation

Cash S&A Expenses

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

Step: 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

Governmental And Nonprofit Accounting Theory And Practice

Authors: Robert J Freeman, Craig D Shoulders, Gregory S Allison, Terry K Patton, Robert Smith,

9th Edition

0132552728, 9780132552721

More Books

Students also viewed these Accounting questions

Question

★★★★★

What is the difference between using brainstorming and the Delphi technique for risk identification? What are some of the advantages and disadvantages of each approach? Describe the contents of a...

Answered: 1 week ago

Question

★★★★★

Find the values of V1, R2, and V3 inFigure. R2 8.75 1 3.75 A E-120V 75.0 V 3.25

Answered: 1 week ago

Question

★★★★★

=+c) Which regression would you select for understanding the interplay of these nutrition components. Explain. (Note: Both are defensible.)

Answered: 1 week ago

Question

★★★★★

Alard Company produces blenders and coffee makers. During the past year, the company pro-duced and sold 65,000 blenders and 75,000 coffee makers. Fixed costs for Alard totaled $340,000,of which...

Answered: 1 week ago

Question

★★★★★

Scenario: CityOfTech ISP Inc. 10.0.0.0/8 Using the available network, the CityOfTech ISP's network administrators must create 7,231 sub-networks to accommodate their distribution to facilities across...

Answered: 1 week ago

Question

★★★★★

Six years ago you bought 100 shares of CCC and paid the price of the 70. If the next 10 yrs are identical to the last 6 yrs, what is your estimate of the value of your 100 shares in 10 yrs?

Answered: 1 week ago

Question

★★★★★

5.Discuss supply and demand dynamics in the short-term Treasuries market. What factors are driving the current scarcity in the market and what is the impact of this scarcity on prices/yields?

Answered: 1 week ago

Question

★★★★★

Explain the pages in white the expert taxes

Answered: 1 week ago

Question

★★★★★

The EAI data has information on the annual incomes of managers and whether they have attended the training program or not. This data comprise all the 2500 managers that work for this organization....

Answered: 1 week ago

Question

★★★★★

For workers' compensation in the state of Massachusett , What are the benefits and drawbacks of workers' compensation to employers and employees?

Answered: 1 week ago

Question

★★★★★

Kyles Manog has taken the pop world by storm over the first six months of his career and has asked you to prepare some financial statements for that trading period. Income Kyles sold 4 0 , 0 0 0 DVD...

Answered: 1 week ago

Question

★★★★★

4. Present multiple themes at once. Then you will get to know a little about how others think, when some of the themes are rejected.

Answered: 1 week ago

Question

★★★★★

5. Get a third party to mediate, so that both parties have the opportunity to go back to their original negotiating point that they had before the third party put forward his/her proposal.

Answered: 1 week ago

Question

★★★★★

1. Discuss the following statements: a) What we seek to achieve is different from why we seek to achieve it. b) Thoughts are different from what we are thinking about. c) Writing to find out what one...

Answered: 1 week ago

Previous Question Next Question

Sales Budget	Quarter #1	Quarter #2	Quarter #3	Quarter #4	Total
Sales in Units	2,250	2,900	1,750	1,750	8,650
Selling Price per Unit	$48	$48	$48	$48	$48
Sales Revenue	$108,000	$139,200	$84,000	$84,000	$415,200

Expected Cash Collections	Quarter #1	Quarter #2	Quarter #3	Quarter #4	Total
Accounts Receivable
Current month sales	$59,400	$76,560	$46,200	$46,200	$228,360
Last month sales		$48,600	$62,640	$37,800	$149,040
	$59,400	$125,160	$108,840	$84,000	$377,400

Production Budget	Quarter #1	Quarter #2	Quarter #3	Quarter #4	Total
Sales In Units	2,250	2,900	1,750	1,750	8,650
Add: Desired Ending Inventory	725	437.5	437.5	575	575
Total Needs	2,975	3,337.5	2,187.5	2,325	9,225
Less: Beginning Finished Goods Inventory	200	725	437.5	437.5	200
Units To Be Produced	2,775	2,612.5	1,750	1,887.5	9,025

Direct Materials Purchases	Quarter #1	Quarter #2	Quarter #3	Quarter #4	Total	Direct Materials Purchases	Quarter #1	Quarter #2	Quarter #3	Quarter #4	Total
Units To Be Produced	2,775	2,612.5	1,750	1,887.5	9,025	Units To Be Produced	2,775	2,612.5	1,750	1,887.5	9,025
Materials Per Unit	5	5	5	5	5	Materials Per Unit	3	3	3	3	3
Production Needs	13875	13063	8750	9438	45125	Production Needs	8325	7838	5250	5663	27075
Add: Desired Ending Inventory	3918.75	2625	2831.25	3375	3375	Add: Desired Ending Inventory	2351.25	1575	1698.75	2025	2025
Total Needed	17794	15688	11581	12813	48500	Total Needed	10676	9413	6949	7688	29100
Less: Beginning Inventory	450	3918.75	2625	2831.25	450	Less: Beginning Inventory	0	2351.25	1575	1698.75	0
Materials To Be Purchased	17344	11769	8956	9981	48050	Materials To Be Purchased	10676	7061	5374	5989	29100
Materials Cost Per Ounce	$0.75	$0.75	$0.75	$0.75	$0.75	Materials Cost Per Ounce	$0.40	$0.40	$0.40	$0.40	$0.40
Total Materials Purchase Cost	$13,007.81	$8,826.56	$6,717.19	$7,485.94	$36,037.50	Total Materials Purchase Cost	$4,270.50	$2,824.50	$2,149.50	$2,395.50	$11,640

Cash Purchases Budget	Quarter #1	Quarter #2	Quarter #3	Quarter #4	Total
Accounts Payable 3/31
Current Month Purchases	$7,775.24	$5,242.98	$3,990.01	$4,446.65	$21,454.88
Last Month Purchases		$9,503.07	$6,408.08	$4,876.68	$20,787.83
Total Cash Disbursements For Purchases	$7,775.24	$14,746.05	$10,398.09	$9,323.33	$42,242.71

Direct Labor Budget	Quarter #1	Quarter #2	Quarter #3	Quarter #4	Total
Units To Be Produced	2,775	2,612.5	1,750	1,887.5	9,025
DL Hours Needs Per Unit	0.8	0.8	0.8	0.8	0.8
DL Hours Needed	2,220	2,090	1,400	1,510	7,220
DL Cost Per Hour	$18.75	$18.75	$18.75	$18.75	$18.75
Total Budgeted DL	$41,625	$39,187.5	$26,250	$28,312.5	$135,375

Overhead Budget	Quarter #1	Quarter #2	Quarter #3	Quarter #4	Total
DL hours needed	2,220	2,090	1,400	1,510	7,220
VOH rate / hour	2	2	2	2	2
Budgeted variable OH	4,440	4,180	2,800	3,020	14,440
Budgeted fixed MOH costs	8,500	8,500	8,500	8,500	34,000
Total budgeted OH expense	12,940	12,680	11,300	11,520	48,440
Less: Depreciation	1,750	1,750	1,750	1,750	7,000
Total cash disbursements for MOH	11,190	10,930	9,550	9,770	41,440

Ending Finished goods
Production costs per unit	Quantity	Cost	Total
Direct materials
Direct labor
MOH

Budgeted finished goods inventory
Ending inventory, in units
Unit product cost
Ending finished goods inventory

Selling and Administrative Expense Budget	Quarter #1	Quarter #2	Quarter #3	Quarter #4	Total
Budgeted sales
Variable S&A rate
Variable expenses
Fixed S&A
Total S&A
Less: Depreciation
Cash S&A Expenses