Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

Please answer both questions. I need help answering them. Below is the statements provided for the problems.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed 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 volume

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Your Human Resources Department A Step By Step Guide

Authors: John H. McConnell

1st Edition

0814474675, 978-0814474679

More Books

Students also viewed these Accounting questions

Question

I am paid fairly for the work I do.

Answered: 1 week ago

Question

I receive the training I need to do my job well.

Answered: 1 week ago