Score: 0 of 3 pts Question Help E9-35A (similar to) You recently began a job as an accounting intern at Randell Adventures. Your first task was to help prepare the cash budget for February and March Unfortunately, the computer with the budget fle crashed, and you did not have a backup or even a hard copy You ran a program to salvage bits of data from the budget file Alter entering the following data in the budget, you may have just enough information to reconstruct the budget Click the icon to view information on borrowing cash) Requirements Complete the following cash budget (For amounts with a 50 balance, make sure to enter "U" in the appropriate input field Entor cash deficiencies with a minus sign or parentheses Enter the net total effects of financing with a minus sign when the amount is a net outflow Round inforest expense to the nearest whole dollar) Randell Adventures Combined Cash Budget February and March February Beginning cash balance $ 16.200 Plus Cash collections 0 More info Plus Cash from sale of plant assets Totalcash avariable $ 106 500 Loss Cash payments (purchase inventory) Randell Adventures eliminates any cash deficiency by borrowing the exact amount needed from State Loss Cash payments (operating expenses) 47.900 Street Bank, where the current interest rate is 7% Randell Adventures pays interest on its outstanding debit at the end of each month. The company also repays all borrowed amounts at the end of the month as cash $ 98,600 becomes available (1) Eng cash balance before financing Minimum cash balance desired 22,000 Print Done Enter any number in the edit fields and then click Check Answer Check Answer Clear All Ahmed Reeds, a manufacturer of saxophone, oboe, and clarinet reeds, has projected sales to be $896,000 in October, 1968,000 in November, $1,045,000 in December, and $938,000 in January Ahmed's sales are 20% cash and 80% credit. The company's collection history indicates that credit sales are collected as follows: 25% in the month of the sale 60% in the month after the sale 14% two months after the sale 1% are never collected Requirements 1. Prepare a sales budget for all four months, showing the breakdown between cash and credit sales 2. Prepare a cash collection budget for December and January Round all answers up to the nearest dollar Requirement 1. Prepare a sales budget for all four months, showing the breakdown between cash and credit sales Ahmed Reeds Sales Budget For the Four Months Ended January October November December January Cash sales $ 179,200 $ 193,000 $ 209,000 $ 187,600 716,800 Credit sales 774,400 836,000 750,400 800.000 $ 968,000 $ 1045,000 $38.000 Total sales Requirement 2. Prepare a cash collection budget for December and January. Round all answers up to the nearest dollar Ahmad Raadle Enter any number in the edit fields and then click Check Answer Allartehan Al Al Ahmed Reeds, a manufacturer of saxophone, oboe, and clarinet reeds has projected sales to be $896,000 in October, 5968,000 in November, $1,045,000 in December, and $938,000 in January. Ahmed's sales are 20% cash and 80% credit. The company's collection history indicates that credit sales are collected as follows: 25% in the month of the sale 60% in the month after the sale 14% two months after the sale 19 are never collected Requirements 1. Prepare a sales budget for all four months, showing the breakdown between cash and credit sales 2. Prepare a cash collection budget for December and January. Round all answers up to the nearest dollar Ahmed Reeds Budgeted Cash Collections from Customers For the Months of December and January December January Cash sales Collection of credit sales 25% of current month credit sales 60% of prior month credit sales 14% of credit sales two months ago Total collection of credit sales Total cash collections Enter any number in the edit fields and then click Check Answer. Kyler Manufacturing produces self-watering planters for use in upscale retail establishments. Sales projections for the first five months of the upcoming year show the estimated unit sales of the planters each month to be as follows: (Click the icon to view additional information) Inventory at the start of the year was 850 planters. The desired inventory of planters at the end of each month should be equal to 25% of the following month's budgeted sales Each planter requires three pounds of polypropylene (a type of plastic). The company wants to have 20% of the polypropylene required for next month's production on hand at the end of each month. The polypropylene costs $0.20 per pound Read the requirements Kyler Manufacturing Direct Materials Budget For the Months of January through March January February March Data Table Quarter Units to be produced 3,500 3,675 3,700 10,875 3 3 3 3 Quantity of direct materials needed per unit Multiply by 10,500 Quantity needed for production 11,025 11,100 32,625 Number of planters to be sold 2,205 Plus 2.220 Desired ending inventory of direct materials 2,895 January .... 2,895 3,400 Total quantity needed 13,245 February 12,705 13,905 3,800 35,520 March. 850 Less 3,300 2 205 2,220 Beginning inventory of direct materials April 4,900 Quantity to purchase 11855 11,040 15405 39150 May 4,600 Multiply byCost per pound $ 020 $ 0.20 $ 0.20 $ 020 2371 $ 2,208 3081 7830 Total cost of direct material purchases Print Done 4425 Done Enter any number in the edit fields and then click Check