chapter 9 managerial accounting excel

NEVIG View 29 Wrap Text LD Calibri (Body) 11 A A = = BIU AA EE Paste Merge & Center Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. A1 x fx Please complete Quick Study as follows: A B C D E F G H I K L 1 Please complete Quick Study as follows: M 3 4 1) From our textbook Beginning finished goods inventory is 10,000 units, anticipated sales volume is 60,000 units, and the de s ired ending finished goods inventory is 12,000 units. What number of units should be produced S 14 2) New Jane's sales department predicts sales of $250,000 for March and $310,000 for the month of April. The Accounts Receivable department discloses that sales are usually received 50% in the month of sale and 50% in the month following Create a cash receipts schedule for April, to convert sales to cash receipts to be used in the cash budget. 25 3) 26 From our textbook Johnson Manufacturing Company has budgeted 30,000 direct labor hours for March. The budgeted cost formula for monthly manufacturing overhead is $4 per direct labor hour plus $65.000. What is the manu- facturing overhead budget for March? Problem -9 EX 10-12 DO O S