please help me

question seven please

Rosie owns and operates Sunshine Berries, which sells a variety of berries and other summer fruits. Rosie is unsure why the business is not doing as well as she thought it would, especially given recent growth in sales. Her accountant suggested that she start preparing cash budgets for the business. Rosie has compiled the following figures: 2022 Estimates Apr May Jun Jul Sales $35,750 $41,250 $42,900 $42,900 Purchases 17,875 20,625 21,450 21,450 Wages 6,000 6,000 6,000 6,000 Selling expenses 3,600 3,600 3,600 2,600 Depreciation 750 750 750 750 Additional information: The bank balance at March 31, 2022 is expected to be $3,000. All customers are given 30-day credit terms, however 60 per cent choose to pay cash. Past experience shows that debtors usually settle their accounts according to the following pattern: 80 per cent in the month following the sale 15 per cent in the second month following the sale 5 per cent in the third month following the sale Actual sales figures for 2022 are as follows: January: $32,450 February: $33,000 March: $30,800 Seventy (70) per cent of the purchases of the berries and fruit are paid for in the month of purchase, with the remainder paid for in the following month. Purchases in March 2022 are $15,400. Annual insurance expense of $4,800 for the 12-month period from January to December 2022 was paid in January 2022. The monthly insurance amount is included in the selling expenses figure above New office equipment will be purchased in April for $7,200 and will be paid for in May. Interest of $1,200 is charged at the end of each quarter for the existing loan and paid in the first month of the following quarter. Principal repayments are $6,500 per month. Additional cash can be borrowed from the bank monthly at an interest rate of 9.00 per cent per annum. Interest is charged monthly in the month following the borrowing. 7. Using the Cash Budget Template (MS Excel) provided in Module 3, prepare a summary cash budget for Sunshine Berries for the April - June 2022 quarter. Include a copy of the summary cash budget in your document containing your written assignment answers. (9 marks) begin hy prac budges would be used for even in het nanagement entire 2 peormance of Sunshine 1 Dalan to Recame they components of reward Eglanti, respecter low variantenned performance in your distinguish between budgets 5. budget for Sucheme for the 2022 Includede of them receptes but in your document come your written Use the Catheter Merwe disbursement budget for Suite Berties for the Fortune2022 relacute.com recordibuents but in your document certain wie wets A continued 2 Using the Cash Budget Templates provided in Module.ph budget for Shine Barries for the pril-June/022carterInclude a copy of the man chat in your de content containing your writes En Rose in peccato mohlo 2.000 bonherbe AND the active on her cah te cel Note: To be awarded these murs you need to cely complete the que te kort la course page hingat per AND comdia to your agent Wond tie the steer todas esperantiste Norskellence powing the one for Marks we del fumetted verts, and the very copied Excelente Word Formater Tot 100 ml Agent content Argument continued Background information Reseens and operates Sunshine Berries, which every brand others Both why the bones is not as well as she thought with me growth in het contant de the start och bor the Reithas complete flowing 2003timate May kom Seles 535. S420 42.00 Purch 2005 21450 140 4.000 6.000 . Seline 1600 1.600 Deore 30 Additional fortion The balance Merc 31, 2022 speed to be 53000 Alstomers are credem nowe percent . Pulance shows that all the dining putem 15 percent in the second month following the Spesent in the third mothewige Actuales figures for flow may 512.50 February $1.00 Mard. S70 percent of the purchase of the bemanded for the month Durch with the reminder for helewing Mach2022 Annual nource expense 4.200 to the 12 month period tonnary to become 2002 was part 2022. The only suded in the line prove hewater wille einer for 2.200 wiedy erest of $1.200 to changed at the end of each quarter to the site condade First north of the flow 56.00 . Additional cash can be borewed from the bank monthly time per Interested monthly the month on the bring $15.00 Aigrement continued Required Use the background information in the recomand any other formation you believe want to the following in the bodgettem provided to de Gevaate on the real team coure per Show All woning information Round your budget there were the Dideo 1 where budgets would be for use in het management of the Et sewe Rosie owns and operates Sunshine Berries, which sells a variety of berries and other summer fruits. Rosie is unsure why the business is not doing as well as she thought it would, especially given recent growth in sales. Her accountant suggested that she start preparing cash budgets for the business. Rosie has compiled the following figures: 2022 Estimates Apr May Jun Jul Sales $35,750 $41,250 $42,900 $42,900 Purchases 17,875 20,625 21,450 21,450 Wages 6,000 6,000 6,000 6,000 Selling expenses 3,600 3,600 3,600 2,600 Depreciation 750 750 750 750 Additional information: The bank balance at March 31, 2022 is expected to be $3,000. All customers are given 30-day credit terms, however 60 per cent choose to pay cash. Past experience shows that debtors usually settle their accounts according to the following pattern: 80 per cent in the month following the sale 15 per cent in the second month following the sale 5 per cent in the third month following the sale Actual sales figures for 2022 are as follows: January: $32,450 February: $33,000 March: $30,800 Seventy (70) per cent of the purchases of the berries and fruit are paid for in the month of purchase, with the remainder paid for in the following month. Purchases in March 2022 are $15,400. Annual insurance expense of $4,800 for the 12-month period from January to December 2022 was paid in January 2022. The monthly insurance amount is included in the selling expenses figure above New office equipment will be purchased in April for $7,200 and will be paid for in May. Interest of $1,200 is charged at the end of each quarter for the existing loan and paid in the first month of the following quarter. Principal repayments are $6,500 per month. Additional cash can be borrowed from the bank monthly at an interest rate of 9.00 per cent per annum. Interest is charged monthly in the month following the borrowing. 7. Using the Cash Budget Template (MS Excel) provided in Module 3, prepare a summary cash budget for Sunshine Berries for the April - June 2022 quarter. Include a copy of the summary cash budget in your document containing your written assignment answers. (9 marks) begin hy prac budges would be used for even in het nanagement entire 2 peormance of Sunshine 1 Dalan to Recame they components of reward Eglanti, respecter low variantenned performance in your distinguish between budgets 5. budget for Sucheme for the 2022 Includede of them receptes but in your document come your written Use the Catheter Merwe disbursement budget for Suite Berties for the Fortune2022 relacute.com recordibuents but in your document certain wie wets A continued 2 Using the Cash Budget Templates provided in Module.ph budget for Shine Barries for the pril-June/022carterInclude a copy of the man chat in your de content containing your writes En Rose in peccato mohlo 2.000 bonherbe AND the active on her cah te cel Note: To be awarded these murs you need to cely complete the que te kort la course page hingat per AND comdia to your agent Wond tie the steer todas esperantiste Norskellence powing the one for Marks we del fumetted verts, and the very copied Excelente Word Formater Tot 100 ml Agent content Argument continued Background information Reseens and operates Sunshine Berries, which every brand others Both why the bones is not as well as she thought with me growth in het contant de the start och bor the Reithas complete flowing 2003timate May kom Seles 535. S420 42.00 Purch 2005 21450 140 4.000 6.000 . Seline 1600 1.600 Deore 30 Additional fortion The balance Merc 31, 2022 speed to be 53000 Alstomers are credem nowe percent . Pulance shows that all the dining putem 15 percent in the second month following the Spesent in the third mothewige Actuales figures for flow may 512.50 February $1.00 Mard. S70 percent of the purchase of the bemanded for the month Durch with the reminder for helewing Mach2022 Annual nource expense 4.200 to the 12 month period tonnary to become 2002 was part 2022. The only suded in the line prove hewater wille einer for 2.200 wiedy erest of $1.200 to changed at the end of each quarter to the site condade First north of the flow 56.00 . Additional cash can be borewed from the bank monthly time per Interested monthly the month on the bring $15.00 Aigrement continued Required Use the background information in the recomand any other formation you believe want to the following in the bodgettem provided to de Gevaate on the real team coure per Show All woning information Round your budget there were the Dideo 1 where budgets would be for use in het management of the Et sewe