Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
Prepare selected quarterly operating budgets. P 6 . 1 ( L 0 1 , 2 , 3 ) , AP Excel Harmony's sling - bag
Prepare selected quarterly operating budgets. PL AP Excel Harmony's slingbag company is now in its sixth year of operations. She credits much of her success to her hardworking greataunt, who taught Harmony the value of planning. Harmony realizes she can't plan for every scenario, but she can plan for the most likely ones. This mindset is essential to Harmony when it is time to budget for her business. She gathers the most likely sales volumes and resource usages for the upcoming period as follows. Budgeted sales volume tableBudgeted Resource Usage for One Unit,,Budgeted Resource CostsDM: square yards of fabric,$ per square yard,DM: linear yard of lightweight rope,$ per linear yard,DL: minutes of direct labor time,$ per DL hour,VariableMOH: minutes of machine time,$ per machine hour, Additional information: Budgeted selling price per unit: $ Target ending FG inventory of sling bags: of following month's sales volume. Target ending DM inventory of fabric: of following month's production needs. Target ending DM inventory of rope: of following month's production needs. Budgeted fixedMOH costs: supervisor salaries of $ per month, depreciation on plant assets of $ per month, property taxes and insurance of $ per month. Required a Prepare the following monthly budgets for the upcoming first quarter for Harmony's slingbag business present quarter totals for each budget, as well Sales forecast. Production budget. DM purchases budget for i fabric and ii rope. DL budget. MOH budget. b Explain how using the most realistic information possible in Harmony's budgets might affect her employees' motivation in meeting the budget for sales and in not exceeding the budgets in the production areas included above c Explain what other approaches Harmony might use to help generate more buyin for these budgets.
Prepare selected quarterly operating budgets.
PL AP Excel Harmony's slingbag company is now in its sixth year of operations. She credits much of her success to her hardworking greataunt, who taught Harmony the value of planning. Harmony realizes she can't plan for every scenario, but she can plan for the most likely ones. This mindset is essential to Harmony when it is time to budget for her business. She gathers the most likely sales volumes and resource usages for the upcoming period as follows.
Budgeted sales volume
tableBudgeted Resource Usage for One Unit,,Budgeted Resource CostsDM: square yards of fabric,$ per square yard,DM: linear yard of lightweight rope,$ per linear yard,DL: minutes of direct labor time,$ per DL hour,VariableMOH: minutes of machine time,$ per machine hour,
Additional information:
Budgeted selling price per unit: $
Target ending FG inventory of sling bags: of following month's sales volume.
Target ending DM inventory of fabric: of following month's production needs.
Target ending DM inventory of rope: of following month's production needs.
Budgeted fixedMOH costs: supervisor salaries of $ per month, depreciation on plant assets of $ per month, property taxes and insurance of $ per month.
Required
a Prepare the following monthly budgets for the upcoming first quarter for Harmony's slingbag business present quarter totals for each budget, as well
Sales forecast.
Production budget.
DM purchases budget for i fabric and ii rope.
DL budget.
MOH budget.
b Explain how using the most realistic information possible in Harmony's budgets might affect her employees' motivation in meeting the budget for sales and in not exceeding the budgets in the production areas included above
c Explain what other approaches Harmony might use to help generate more buyin for these budgets.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started