please show computation:
Please print this assignment out and complete manually, or type your answers on this document and then print. Assignments completed on folder paper will not be accepted/graded. Please put answers to each requirement on the blank line provided. In order to get credit for any of the answers, you must provide supporting computations in the space provided. d) Feathered Friends, Inc., a producer of bird feeders is preparing its budget for December 2019. The budget director has gathered the following data from various managers for use in developing the budgeted income statement for December 2019: a) The Sales Manager estimated sales of 31,000 units in November 2019; 32,500 units in December 2019; and 36,000 units in January 2020. They are expected to be sold for $50 per unit. b) The Production Manager anticipates having 3,250 bird feeders on hand at December 1. These bird feeders are expected to have cost $22 per unit to produce. His production plan for December is to produce enough to have a desired inventory equal to 10% of the following month's budgeted sales. c) The bird feeders are made with wood. Each bird feeder requires 0.80 feet of wood. Each foot of wood is expected to cost $6.00. The Purchasing Manager expected to have 500 feet of wood on hand on December 1 and would like to have 600 feet on hand on December 31. e) The Production Manager notified the Human Resource Manager that each bird feeder requires 0.4 direct labor hours to produce. The Human Resource Manager indicates that the average hourly pay rate is $15 per hour. The Production Manager estimates the variable overhead costs are $7.00 per direct labor hour. Fixed overhead costs consist of $60,000 of depreciation expense and $200,000 of other overhead items (salaries, rent, utilities, insurance, etc.). Based on the annual budget, the predetermined overhead rate (for total overhead) is $27 per direct labor hour Selling and administrative expenses, including $50,000 of depreciation expense are expected to be $500,000 for December. The Sales Manager estimates that 30% of total sales are cash sales with the remainder on account. The Accounting Manager estimates that 20% of credit sales are collected in the month of sale with the remaining 80% collected in the month following sale. Material purchases, direct labor, factory overhead and selling and administrative expenses are paid for in the month incurred The Accounting Manager expects that the cash balance on December 1 will be $400,000 Requirements: 1) Using item a), the budgeted Sales Revenue for December is: OD 2) Using items a) and b), calculate the budgeted production for December: units 3) Using items c) and d) and your answer to requirement 2, calculate the budgeted feet of wood that must be purchased in December: feet 4) Using item c) and your answer to requirement 3. calculate the budgeted cost of wood purchases for December: $ distribog 152 5) Using item e) and your answer to requirement 2, calculate the budgeted direct labor hours required for December: hours 6) Using item e) and your answer to requirement 5, calculate the budgeted direct labor costs for December: $ 7) Using item f) and your answer to requirements, calculate the budgeted variable overhead costs for December $_ 8) Using item f), calculate the budgeted fixed overhead costs for December Using items c), e) and g) calculate the average budgeted cost of producing one birdhouse in December $_ A budapestremame nt 10) Using items a), b) and your answer to requirement 9, calculate the budgeted Cost of Goods Sold for December assuming units in beginning inventory are sold before any units produced in the current period (FIFO):$_ -- Using item h) and your answer to requirements 1 and 10, calculate the budgeted Net Income for December: $ 12) Using item i) and sing item i) and your answer to requirement 1, calculate the budgeted cash sales for December: $ 13) Using item i) and your answer to requirement 1, calculate the budgeted credit sales for December: $ 14) Using items a) and ]) and your answers to requirements 12 and 13, calculate the budgeted cash receipts for December: $ 15) Using item and your answer to requirement 13, calculate the budgeted Accounts Receivable balance for December 31, 2019:$_ to 100 bat bud o OL culos naman po obos idmat 16) Using items f) and h) and your answers to requirements 4, 6, 7 and 8, calculate the budgeted cash payments for December: $ 17) Using item I) and your answers to requirements 14 and 16, calculate the budgeted cash balance for December 31, 2019:$_
