Excel

Stanford Enterprises uses job-order costing. Jverhead is applied on the basis of direct labor hours. The following information relates to the year just ended. Data: Estimated total overhead costs Estimated total direct labor hours Actual total direct labor hours Actual costs for the year: Purchase of raw (direct) materials Direct labor cost Manufacturing overhead $275,000 25,000 27,760 Inventories: Raw (Direct) Materials Work in Process Finished Goods Required: Use the data to fill in the following information. (Use cells B6 to C18 from the given information to complete this question. If overhead is negative value. All answers should be input and displayed as positive values.) 1. Overhead: Actual overhead cost Predetermined overhead rate Actual direct labor hours Total overhead applied (Over) or under applied overhead Legend Graded cell: Leave blank if no needed. Scratchpad Use as a non-grad workspace 3. Prepare a schedue of cost of goods sold. (Use ceils 86 to C18 from the given information to complete this question. If overhead I: negative value. Al answers should be input and displayed as positive values.) (Use cells B6 to C18 from the given information to complete this question. If overhead i: negative value. All answers should be input and displayed as positive values.) Legend Graded cell: Leave blar needed. Scratchpad: Use as and workspace