Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please answer both questions. I need help answering them. Below is the statements provided for the problems. Use the Westfield Corporation case to answer questions
Please answer both questions. I need help answering them. Below is the statements provided for the problems.
Use the Westfield Corporation case to answer questions 113. 11. Why is Cash (line 5) on Westfield's balance sheet, the same as line 28 "Total - cash and equivalents at the end of the year" on the company's cash flow statement? Cannot tell from the information provided The cash flow statement summarizes the cash activities for the year to sum the cash at the end of the year Just a coincidence The balance sheet summarizes the cash activities for the year to sum the cash at the end of the year and on the cash flow statement Question 12 0.5pts Use the Westfield Corporation case to answer questions 1 - 13. 12. During planning for the upcoming year, Westfield management must ensure that the company stays within the loan covenants set by its lender. From the following, which is an example of one of the loan covenants for year 9? Minimum margin of 6% Minimum times interest earned ratio of 8 Minimum current ratio of 3 The loan is unsecured \begin{tabular}{lrrrr} Schedule 3 & \multicolumn{3}{c}{ Proforma } \\ Regular Time Direct Labor (DL) & Year 6 & Year 7 & Year 8 & Year 9 \\ Hours worked in year & 2,000 & 2,000 & 2,000 & 2,000 \\ Average wage rate & $14.00 & $14.35 & $14.65 & $0 \\ Average wages per DL employee & $28,000 & $28,700 & $29,300 & $0 \\ Plus 28\% benefits & $7,840 & $8,036 & $37,504 & 87 \\ Total cost per DL employee & $35,840 & $36,736 & 8.64 & 108.50 \\ Number of DL employees & 66 & 2.42 & 174,000 & 3.29 \\ Number of shifts & 2.00 & 160,000 & $3,262,848 & $0 \end{tabular} Westfield Corporation Schedule 8 - General \& Administrative Expenses Proforma Westfield Corporation Sales Forecast Average Price Projection Year 8 average price Target Market(s) Adjustments Target market(s) Product Adjustments New templates Extensions \& options to current templates New product development Price Adjustments Terms of sale Distribution Adjustments Distribution expansion - California \& New York Distribution expansion - Mexico Promotion Adjustments Advertising Sales promotion Sales rep commission structure Training sales reps Travel Website \& IT Competitive Economic Political, legal, regulatory Social/Cultural Technological Average Price Projection Year 9 24.15 0 0.0898 0.0079 0.085 0.024 0 0.01 0.02 0.01 Environmental Factor Adjustments 0 0.06 0.048 0.036 0 $24.42 \begin{tabular}{lrrr} & Year 9 & Weight & \multicolumn{1}{c}{Year9Weighted} \\ Sales Volume Projection & 1,263,464 & 50.00% & 631,732 \\ Volume Forecast by \# of Sales Reps - Schedule 1 & 1,294,832 & 40.00% & 517,933 \\ Volume Forecast by Areas of Distribution - Schedule 2 & 1,100,167 & 10.00% & 110,017 \\ Volume Forecast by \# of Product Templates - Schedule 3 & & & 1,259,682 \end{tabular} Schedule 1 - Volume Forecast by \# of Sales Reps Number of sales reps Volume Average volume per sales rep Weight Weighted average - Volume per Sales Rep Projected sales volume \begin{tabular}{rrrr} \multicolumn{1}{l}{ Year 6 } & \multicolumn{1}{c}{ Year 7 } & \multicolumn{1}{c}{ Year 8 } & \multicolumn{1}{c}{ Year 9 } \\ 10 & 12 & 14 & 20 \\ 800,000 & 890,000 & 1,010,000 & \\ 80,000 & 74,167 & 72,143 & \\ 20% & 30% & 50% & \\ 16,000 & 22,250 & 36,071 & 74,321 \\ & & & 1,263,464 \end{tabular} Schedule 2 - Volume Forecast by Areas of Distribution Arizona California Florida Georgia Illinois Indiana Michigan New York Ohio Texas Mexico Totals \begin{tabular}{rrrrr} Year 6 & Year 7 & Year 8 & \multicolumn{2}{c}{ Yorecast } \\ & & 40,000 & 74,321 & \# Sales Reps \\ 160,000 & 170,000 & 180,000 & 200,668 & 1 \\ 50,000 & 80,000 & 105,000 & 105,000 & 3 \\ 155,000 & 160,000 & 170,000 & 170,000 & 1 \\ 80,000 & 85,000 & 80,000 & 80,000 & 2 \\ 90,000 & 95,000 & 100,000 & 100,000 & 1 \\ & & & 111,482 & 1 \\ 115,000 & 120,000 & 115,000 & 118,914 & 3 \\ 150,000 & 180,000 & 220,000 & 222,964 & 2 \\ & & & & 3 \\ 800,000 & 890,000 & 1.010,000 & 1,294,832 & 20 \end{tabular} Schedule 3 - Volume Forecast by \# of Product Templates \# of product templates Volume Yearly average sales volume per template Average sales volume per template Projected sales volumeStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started