As the management consultant of Planet Pets, you have been tasked with preparing a cash budget for 6 months (Jan to June) that will be incorporated into the business' overall business plan. The following information has been obtained from the sales department regarding the upcoming sales forecasts for the next six (6) months January to June: Need to merge the two of the product together and Need to clearly show for each month Sales information (in dollars) Nov Dec Jan Feb Mar Apr May June Pet Toys 80,000 110,000 100,000 90,000 85,000 95,000 70,000 62,500 Designer Collars 100,000 150,000 145,000 125,000 95,000 87,500 68,000 60,000 Cash Sales 20% Credit Sales 80% Collected in month of sale 30% Collected in the following month 50% nd Collected in the 2 month following sale 20% The following information has been obtained from the production department regarding the upcoming production forecasts for the next six (6) months. The costs are related to budgeted raw materials and labour costs. Budgeted raw materials and labour costs (in dollars) Cost information in dollars) Nov Dec Jan Feb Mar Apr May June Pet Toys 65,000 85,000 80,000 65,000 72,500 70,000 50,000 41,500 Designer Collars 75,000 105,000 95,000 87,000 85,000 67,500 47,000 48,500 Raw materials and labour are paid as follows % All raw materials and labour: Paid in month incurred 30% Paid in the month following 70%