help filling in rest of chart with blanks.

Homework: Case Study 1 Save Score: 2.62 of 15 pts 1 of 1 (1 complete) HW Score: 17.49%, 2.62 of 15 pts P9-65B (book/static) Question Help Conrad Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Conrad Manufacturing's operations: (Click the icon to view the data.) i (Click the icon to view additional data.) Read the requirements. Total cash collections Requirement 2. Prepare a production budget. (Hint: Unit sales = Sales in dollars / Selling price per unit.) Conrad Manufacturing Production Budget For the Quarter Ended March 31 Month January February March Quarter Unit sales 8,900 9.900 9.200 28.000 Plus: Desired ending inventory 990 20 950 950 Total needed 9,890 10.820 10.150 28,950 Less: Beginning inventory 890 290 920 890 Units to produce 9.000 9.830 9.230 28,080 Requirement 3. Prepare a direct materials budget. (Round your answers to the nearest whole dollar.) Enter any number in the edit fields and then click Check Answer. ? 10 parts remaining Clear All Check AnswerHomework: Case Study 1 Save Score: 2.62 of 15 pts 1 of 1 (1 complete) HW Score: 17.49%, 2.62 of 15 pts Xx P9-65B (book/static) iQuestion Help Conrad Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Conrad Manufacturing's operations: (Click the icon to view the data.) i (Click the icon to view additional data.) Read the requirements. Requirement 1. Prepare a schedule of cash collections for January, February. and March, and for the quarter in total. Conrad Manufacturing Cash Collections Budget For the Quarter Ended March 31 Month January February March Quarter Cash sales S 24,030 $ 26.730 $ 24.840 $ 75,600 Credits sales 53.200 56,070 62.370 171.640 Total cash collections 77,230 82.800 87.210 247.240 Requirement 2. Prepare a production budget. (Hint: Unit sales = Sales in dollars / Selling price per unit.) Conrad Manufacturing Production Budget For the Quarter Forlard March 21 Enter any number in the edit fields and then click Check Answer. ? 10 parts remaining Clear All Check Answerx P9-65B (book/static) Question Help Conrad Manufacturing is preparing its ma i More Info (Click the icon to view the data.) Read the requirements. a. Actual sales in December were $76,000. Selling price per unit is projected to remain stable at $0 per unit throughout the budget period. Sales for the first five months of the upcoming year are budgeted to be as follows: Requirement 1. Prepare a schedule of ce January . . 80,100 Conrad Ma February . . . . . . . . $ 89.100 Cash Collec March 82.800 For the Quarter April. . . . 85,500 May . . . . 77,400 January 24,030 b. Sales are 30% cash and 70% credit. All credit sales are collected in the month following the sale. Cash sales c. Conrad Manufacturing has a policy that states that each month's ending inventory of finished goods should be 10% of the Credits sales 53,200 following month's sales (in units). 77.230 d. Of each month's direct material purchases, 20% are paid for in the month of purchase, while the remainder is paid for in the Total cash collections month following purchase. Two pounds of direct material is needed per unit at $1.50 per pound. Ending inventory of direct materials should be 20% of next month's production needs. Requirement 2. Prepare a production bud e. Most of the labor at the manufacturing facility is indirect, but there is some direct labor incurred. The direct labor hours per unit is 0.03. The direct labor rate per hour is $13 per hour. All direct labor is paid for in the month in which the work is performed. The Conrad direct labor total cost for each of the upcoming three months is as follows: Produ January . . $ 3,510 For the Quiz February . . . 3,834 Enter any number in the edit fields and ? Print Done 10 parts remaining Check AnswerScore: 2.62 of 15 pts 1 of 1 (1 complete) HW Score: 17.49%, 2.62 of 15 p P9-65B (book/static) Question Help Conrad Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Conrad Manufacturing's operations: (Click the icon to view the data.) i (Click the icon to view additional data.) Read the requirements. Month January February March Quarter Units to be produced 9,000 9,830 9,230 28,060 Multiply by: Quantity (pounds) of DM needed per unit Quantity (pounds) needed for production 18,000 19,660 18,460 56, 120 Plus: Desired ending inventory of DM 3,932 3,692 Total quantity (pounds) needed 21,932 23,352 Less: Beginning inventory of DM 3,932 3.692 Quantity (pounds) to purchase 19,420 Multiply by: Cost per pound 1.50 $ 1.50 $ 1.50 $ 1.50 Total cost of DM purchases 29,130 Enter any number in the edit fields and then click Check Answer. 10 parts remaining Clear All Final Check