Please do all parts thank you so muchSolutionNote As per Che

Please do all parts thank you so much!

Solution

Note: As per Chegg Only 4 part can be solved . However, solution for 7 part provided , and left remaining due to time constraint . kindly upload rest of the part seperately.

Schedule of cash collections:
January February March Total
Budgeted Sales 80100 89100 82800 252000
Cash sales @30% 24030 26730 24840 75600
Collections from credit sales:
      December sales 53000 53000
      January sales 56070 56070
      February sales 26730 26730
Total Cash collections 77030 82800 51570 211400
2. Production Budget
January February March Total
Unit Sales 80100 89100 82800 252000
Add: Desired ending inventory 8910 8280 8550 8550
(10% of the next month\'s sale)
Unit require 89010 97380 91350 260550
Less: Beginning inventory 8010 8910 8280 8010
Budgeted Production 81000 88470 83070 252540
3. Direct material budget
January February March Total
Budgeted Production 81000 88470 83070 252540
Direct material per unit (pounds) 2 2 2 2
Direct material required for production 162000 176940 166140 505080
Add: Desired Ending inventory 35388 33228 33876 33876
(20% of net month\'s requirement)
Material Require 197388 210168 200016 538956
Less: Beginning Inventory 32400 35388 33228 32400
Budgeted direct material purchases (units) 164988 174780 166788 506556
Cost per unit 1.5 1.5 1.5 1.5
Direct material purchases 247482 262170 250182 759834
4. Schedule of payments
January February March Total
Direct material purchases 247482 262170 250182 759834
Payments for :
December purchases 43000 43000
January purchses 49496.4 197985.6 247482
February purchases 52434 209736 262170
March purchases 50036.4 50036.4
Payments for direct material purchases 92496.4 250419.6 259772.4 602688.4
5. Direct labor budget
January February March Total
Budgeted production 81000 88470 83070 252540
Direct labor hour per unit 0.03 0.03 0.03 0.03
Direct labor hours 2430 2654.1 2492.1 7576.2
Direct labor rate per hour 13 13 13 13
Direct labor cost 31590 34503.3 32397.3 98490.6
6. Manufacturing overhead budget
January February March Total
Budgeted production 81000 88470 83070 252540
Variable overhead rate per unit 1.4 1.4 1.4 1.4
Variable overhead cost 113400 123858 116298 353556
Fixed overhead:
   Factory Rent 6500 6500 6500 19500
   Other fixed overheads 2900 2900 2900 8700
Total fixed overhead 9400 9400 9400 28200
Total manufacturing overhead 122800 133258 125698 381756
7. Operating expenses budget
January February March Total
Budgeted unit sales 80100 89100 82800 252000
Variable operating expeses per unit 1.2 1.2 1.2 1.2
Variable overhead expenses 96120 106920 99360 302400
Fixed operating expenses 1400 1400 1400 4200
Total operating expenses 97520 108320 100760 306600
 Please do all parts thank you so much!SolutionNote: As per Chegg Only 4 part can be solved . However, solution for 7 part provided , and left remaining due to
 Please do all parts thank you so much!SolutionNote: As per Chegg Only 4 part can be solved . However, solution for 7 part provided , and left remaining due to

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site