can you put numbers 5-8 on a excel spreadsheet ??

H\&BClothing Budget Project ACC 202 - Fall 2023 Due Tuesday, November 14 The H\&BClothing Company manufactures luxury brand silk jackets. Currently the company makes classic style jackets in a single size. The production process involves drawing, cutting, and assembling the pattern pieces. Direct materials include two types of fabric - silk, and viscose for lining. Other materials, such as shoulder pads, stitching threads, buttons, labels, and packaging, are treated as indirect 5. H\&BClothing budgets indirect materials (e.g., shoulder pads, stitching threads, buttons, labels, and packaging) at $35.50 per jacket. H\&BClothing treats indirect labor and utilities as mixed costs. The variable components are $20.00 per jacket for indirect labor and $5.50 per jacket for utilities. The following fixed costs per month are budgeted for indirect labor, $25,000, utilities, $2,200, and other, $22,000. Prepare a Manufacturing Overhead budget. 6. Variable selling and administrative expenses are $45.50 per jacket sold. Fixed selling and administrative expenses are $35,000 per month. These costs are not itemized, i.e., the budget has only two line items - variable operating expenses and fixed operating expenses. Prepare an Operating Expenses budget. 7. Prepare a Budgeted Manufacturing Cost per unit budget. Refer to exhibit 9-11 for guidance. To calculate FMOH /unit calculate total FMOH for the year and divide this by budgeted production for the year. The total production volume for the year is budgeted at 9,500 jackets. 8. Prepare a Budgeted Income Statement for the quarter for H& BClothing. Assume interest expense of \$0, and income tax expense of 21% of income before taxes. Directions: Refer to Chapter 9 (The Master Budget) for guidance in setting up your budgets and schedules. Adapt your schedules for the specific details outlined in the requirements above. Prepare your budgets using Excel. Use formulas and cell references so that any change you make in one budget is carried through to all the budgets. There should be no hard keyed numbers in your formulas. For example, if you change the 'sales volume increase' from 15% to 20% you should see effects of that change throughout the other budgets. Likewise, if the budgeted selling price per jacket changes from $735 to $800 your spreadsheet model should be able to quickly and easily accommodate this change, i.e., change the input cell for budgeted selling price and see the effect on income. H\&BClothing Budget Project ACC 202 - Fall 2023 Due Tuesday, November 14 The H\&BClothing Company manufactures luxury brand silk jackets. Currently the company makes classic style jackets in a single size. The production process involves drawing, cutting, and assembling the pattern pieces. Direct materials include two types of fabric - silk, and viscose for lining. Other materials, such as shoulder pads, stitching threads, buttons, labels, and packaging, are treated as indirect 5. H\&BClothing budgets indirect materials (e.g., shoulder pads, stitching threads, buttons, labels, and packaging) at $35.50 per jacket. H\&BClothing treats indirect labor and utilities as mixed costs. The variable components are $20.00 per jacket for indirect labor and $5.50 per jacket for utilities. The following fixed costs per month are budgeted for indirect labor, $25,000, utilities, $2,200, and other, $22,000. Prepare a Manufacturing Overhead budget. 6. Variable selling and administrative expenses are $45.50 per jacket sold. Fixed selling and administrative expenses are $35,000 per month. These costs are not itemized, i.e., the budget has only two line items - variable operating expenses and fixed operating expenses. Prepare an Operating Expenses budget. 7. Prepare a Budgeted Manufacturing Cost per unit budget. Refer to exhibit 9-11 for guidance. To calculate FMOH /unit calculate total FMOH for the year and divide this by budgeted production for the year. The total production volume for the year is budgeted at 9,500 jackets. 8. Prepare a Budgeted Income Statement for the quarter for H& BClothing. Assume interest expense of \$0, and income tax expense of 21% of income before taxes. Directions: Refer to Chapter 9 (The Master Budget) for guidance in setting up your budgets and schedules. Adapt your schedules for the specific details outlined in the requirements above. Prepare your budgets using Excel. Use formulas and cell references so that any change you make in one budget is carried through to all the budgets. There should be no hard keyed numbers in your formulas. For example, if you change the 'sales volume increase' from 15% to 20% you should see effects of that change throughout the other budgets. Likewise, if the budgeted selling price per jacket changes from $735 to $800 your spreadsheet model should be able to quickly and easily accommodate this change, i.e., change the input cell for budgeted selling price and see the effect on income