Please provide answer for the questions along with formulas and explanation?

PART 6 (B) - PRODUCTION PLANNING 6. BREAK-EVEN ANALYSIS (Enter actual dollars in this part, not thousands.) What is the variable component of the wages cost? 2.14 per unit What is the fixed component of the wages cost? What is the total value of all fixed costs for this firm? What is the variable cost of raw materials? 20.40 per unit What is the total value of all variable costs for this firm? 22.54 per unit What is the firm's break-even point? units 7. Advise whether the client can comfortably achieve the break-even level of sales based on the firm's recent performance and its budgeted level of sales.BUSSIAF Assign 2 Part 6 - Excel lalitha prasanna X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share Cut Calibri - 14 - A A" ab Wrap Text AutoSum - AY O BE Copy + Fill Paste Format Painter BIU - - SA- Merge & Center * % " Conditional Format as Insert Delete Format Sort & Find & Formatting - Table Clear - Filter - Select - Clipboard Font Alignment Number Styles Cells Editing G3 X V fx N BUDGETING The firm has found from past experience that demand for sporting goods is highly variable throughout the year, making budgeting a difficult process. In particular, the firm has found in previous years that sales sometimes decrease sharply in April each year and then increase again in October. Your client has provided you with the following sales figures for the last three months (October to December 2022) as well as sales forecasts for each of the next 12 months. (Note: These sales figures are expressed as the number of thousands of UNITS sold - they are not dollar figures. For example, the firm sold 70,000 sporting goods in October 2022.) 2022 2023 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 70 70 70 70 70 70 42 42 42 42 42 42 70 70 70 You have also been provided with the following information: The sporting goods sell for $34 each. This price is not expected to change during 2023. All values given to you in the rest of this part of the assignment will be in thousands of dollars. All answers that you give in the budgets (Part 6(A))should be expressed in terms of the number of thousands of dollars, rather than the number of dollars. For example, in October 2022, the firm sold 70,000 units at a price of $34 each, resulting in total sales of $2,380,000, but you should just enter 2380 (the number of thousands of dollars) in the cash budget. (However, enter actual dollars in Part 6(B).) All sales are on credit. 50% of sales are collected the month after the sale, 40% are collected in the second month after the sale, and the remaining 10% are collected in the third month after the sale. Cost of sales each month (the value of inventory used in production) is always 60% of sales. The value of inventory at the end of December 2022 was $200. (Remember, that's the number of thousands of dollars. All dollar values will be given this way from now on.) The firm intends to keep inventory at this level throughout January and February, decrease the inventory by 10% by the end of March in anticipation of decreased sales in April, and then increase inventory again to $200 by the end of September in anticipation of increased sales in October. Purchases in November 2022 totalled $1428 and purchases in December 2022 totalled $1428. All purchases are on credit. 50% of purchases are paid for in the month following the month of purchase, and the remaining 50% are paid for two months after the month of purchase. Operating costs (other than purchases of raw materials, wages and depreciation) are budgeted to be $410 per month. Wages (again, shown in thousands of dollars) are budgeted to be as follows for each of next 12 months. Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 300 300 300 240 240 240 240 240 240 300 300 300 Enter Student No. Part 6 - Data & Instructions Part 6 (A) | Part 6 (B) + 74% Type here to search MON X ENG 3:21 PM IN 12/8/2020