Cash Recepts Budget and Accelona Sharmony and for next year, Shah bude the followme Quarter 54,600,000 Quarter 5.100.000 Quarter 5,000,000 Quarter 4 7.000.000 In Shalmar's expec, 10 percent of sales are proud of the spectacolected the 25tected in the wrong the salt and percent we collected the second quarter the theme colected fotel w for the third of the war 4.000.000 for the fourth of the current years 16,450,000 Required: 1. Calculate cash sales and credit sales expected in the last two Gutes of the current and reach outlet at Quarter Cash Sales Credit Sales 3, current year 4. Crest 1. next year 2 2. next year 3, next year 4. Et year PS 2. Construct a cash receipts budget for Sham Company for each quarter of the next yes, showing the cathed the cash collections from celtnes. Il an amount is zero enter"0" Shalimar Company Cash Receipts budget For the Coming Year Quarter Quarter Quarter Quarter Cash sales Received on account from Quarter 2, current yet Quartet 4, current year Quarter 1, next year Quarter 2, next year Quarter 3. next year Quarter 4. next year 88. Total cash receipts 3. What if the recession led Shalmar's top management to assume that in the next year to percent of credit sales would never be collected the expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect ash received in each quarter? Constructed in budget sng the new option Shalimar Company Cash Receipts Budget sedan det ung the Best Shalimar Company Cash Receipts Budget For the Coming Year Quart Quarter Quarte Quarter Cash sale Received on account from Quarter current year Quarter 1, next year Quarter 2, next year Quarter 3. next year lll Q4. next year Totalcach recept ROI and Investment Deco Allard, Inc, presented two years of data for a Frozen Foods Division and its Canned Foods Division Frozen Foods Division Year 1 Year 2 Sales $35,500,000 $38,500,000 Operating income 1.440,000 1.500,000 Average operating assets 3,710,000 3,780,000 Canned Foods Division Sales Operating income Average operating assets Year 1 $12,000,000 630,000 6,000,000 Year 2 512,000,000 520,000 6,000,000 At the end of Year 2, the manager of the Canned Foods Division is concerned about the division's performance. As a result, he is consdering the opportunity to invest in two independent projects. The first is juice boxes for elementary school children. The second is fruit and vegger pouches for kids on the go without the investments, the division expects that Year 2 data will remain unchanged. The expected operating incomes and the ousay red for each investment are as follows: Juice Box Fruit Pouch Operating income $20,000 $15,400 Outlay 230,000 100,000 Juice Box Operating income Outlay 525.000 230,000 Fruit Pouch $15.400 180,000 Allard's corporate headustees has made available up to $570,000 ofis dan Anyot ested by the dison wit be retained by headers and invested to the company's minimum required to retum, 10 percent. Required: Round your answers to four decimal places before converting to a percentage. For example, 06349 would be rounded to .0635 and entered as "6.35" percent 1. Compute the ROI for each investment Juice Box ROD Fruit Pouch ROI 2. Compute the disonal Rol for each of the following four zternatives: The juice box is added b. The fruit pouch is added c. Both investments are added Round your answers to four decimal places before converting to a percentage. For example, 06349 would be rounded to.065 and entered as "6.35 percent 1. Compute the ROL for each vestment Juice Box ROI Fruit Pouch ROI 2. Compute the divisional Rot for each of the flowing formatives a. The juice boxes added b. The lat pouch added c. Both investments are added d. Neither investments made the status quo, is maintained. Assurring that divisional managers are evaluated and rewarded on the basis of rot performance, which akurative do you think the visional manager will chowe) 3. Which of the data analytic types-descriptive diagnostic predictive or prescriptive used in determining which, in new wivestment to make Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products for next year, Shalimar has budgeted the following Quarter $4,600,000 Quarter 2 5,100,000 Quarter 3 5,000,000 Quarter 4 7,600,000 In Shalimar's experience, 10 percent of sales are paid in cash or the sale on account, 65 percent are collected in the quarter of sale, 25 percentare collected in the quarter following the sale, and 7 percentare collected in the second quarter after the sale. The remang 3 percent ever collected. Totales for the id quarter of the current year are 54,900,000 and for the fourth quarter of the current year are 56,850,000 Required: