(a) Prepare a monthly manufacturing overhead flexible budget for each increment of 3,500 direct labor hours over the relevant rang for the year ending December 31, 2022. (List variable costs before fixed costs) Activity Level Direct Labor Hours Variable Costs Indirect Labor Indirect Materials Repairs Utilities Lubricants Total Variable Costs Fixed Costs Supervision Depreciation Insurance Rent Property Taxes Total Fixed Costs Total Costs Direct Labor Hours Variable Costs (D) Prepare a flexible budget report for October. (List variable costs before fixed costs) Lubricants Indirect Labor Indirect Materials Repairs Utilities Total Variable Costs Fixed Costs Rent Supervision Depreciation Insurance Property Taxes Total Fixed Costs Total Costs 000000 PINA COLADA COMPANY Packaging Department Monthly Manufacturing Overhead Flexible Budget For the Year 2022 4 Budget 10000 000000 PINA COLADA COMPANY Packaging Department Manufacturing Overhead Flexible Budget Report For the Month Ended October 31, 2022 Actual Costs 000000 0000000 2.71 .... Difference Favorable Infavorable her Favorable Unfavorable Unfavorable
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Please do not give solution in image format thanku
![Pina Colada Company estimates that 306,000 direct labor hours will be worked during the coming year, 2022, in the Packaging
Department. On this basis, the following budgeted manufacturing overhead cost data are computed for the year.
Fixed Overhead Costs
Supervision
Depreciation
Insurance
Rent
Property taxes
$97.920
73,440
30,600
24,480
18,360
$244,800
Variable Overhead Costs
Indirect labor
Indirect materials
Repairs
Utilities
Lubricants
$128,520
91,800
70,380
73,440
18,360
$382,500
It is estimated that direct labor hours worked each month will range from 27,100 to 37,600 hours.
During October, 27,100 direct labor hours were worked, and the following overhead costs were incurred.
Fixed overhead costs: supervision $8,160, depreciation $6,120, insurance $2.507, rent $2,040, and property taxes $1,530.
Variable overhead costs: indirect labor $12,673, indirect materials $7,838, repairs $6,132, utilities $6,968, and lubricants $1,954.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F4cf9133d-2dd4-45f6-b833-be7167a81438%2Fe6280c9a-5f39-44c1-9841-2c884f89117c%2Fva4znh8_processed.jpeg&w=3840&q=75)
![(a) Prepare a monthly manufacturing overhead flexible budget for each increment of 3,500 direct labor hours over the relevant rang
for the year ending December 31, 2022. (List variable costs before fixed costs.)
Activity Level
Direct Labor Hours
Variable Costs
Indirect Labor
Indirect Materials
Repairs
Utilities
Lubricants
Total Variable Costs
Fixed Costs
Supervision
Depreciation
Insurance
Rent
Property Taxes
Total Fixed Costs
Total Costs
Direct Labor Hours
(D) Prepare a flexible budget report for October. (List variable costs before foxed costs)
Variable Costs
Lubricants
Indirect Labor
Indirect Materials
Repairs
Utilities
Total Variable Costs
Fixed Costs
Rent
Supervision
Depreciation
Insurance
Property Taxes
Total Fixed Costs
Total Costs
$
4
PINA COLADA COMPANY
Packaging Department
Monthly Manufacturing Overhead Flexible Budget
For the Year 2022
Budget
10000
PINA COLADA COMPANY
Packaging Department
Manufacturing Overhead Flexible Budget Report
For the Month Ended October 31, 2022
Actual Costs
2.71
1000
Difference
Favorable
Infavorable
her Favorable
Unfavorable
Unfavorable](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F4cf9133d-2dd4-45f6-b833-be7167a81438%2Fe6280c9a-5f39-44c1-9841-2c884f89117c%2Fk845jt_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)