requirement 2 complete the schedule of cost of goods manufactured step 3 not step 2
Requirement 2 Complete the Schedule of Cost of Goods Manufactured Always use cell references and formulas where appropriate to receive full credit. All values should be added as poutive number Fremont Troll House Cookies Schedule of Cost of Goods Manufactured Month Ended March 31, 2018 Beginning Work in Process Inventory Cost of Goods Manufactured Requirement 3 Using the results from Requirement 2, calculate the cost per unit for goods manufactured assuming 16,000 units were manufactured, (Always use cell references and formulas where appropriate to receive full credit. Al values should be added as positive numbers.) Cost of Goods Manufactured Total Units Produced Unit Product Cost values other than the value for Ending Work in Process inventory should be entered as positive values. Use minus sign to enter the value for Ending Work in Process Inventory Cell Hint: 0111013, 16, C5 Use the numeric values from the instructions tab for calculations. Do not use an equal in (e) when entering a single numeric value Use the SUM) function to calculate the total manufacturing costs incurred during period. All answers should be entered in the blue highlighted cells.) Fremont Troll House Cookies has been baking coconut cookies for 27 years, Classify manufacturing costs, and prepare schedules for the cost of Goods Manufactured and the Cost of Goods Sold for the month ended March 31, 2018. Use Excel to classify costs as described below. (18 pts) a. Classify the costs as either period costs or product costs. To classify the cost, click in the cell. A drop down arrow will appear to the right. Click the arrow and select either Product or Period. b. Classify the product costs as direct materials, direct labor, or manufacturing overhead. To identify the classification, click in the cell. A drop down arrow will appear to the right, Click the arrow. If it's a product cost, select direct materials, direct labor, or manufacturing overhead. If it's a period cost, select expense. Complete the Schedule of Cost of Goods Manufactured. Use the blue shaded areas for inputs. Use the following amounts: direct materials used, $2,500; direct labor, $3,000; manufacturing overhead, $11,000; beginning work-in-process inventory, $1,500; and ending work-in-process inventory, $1,200. (18 pts) a. Complete the heading b. To select the correct report caption, click in the cell. A dron down arrow will appear to the right. Click the arrow and select the appropriate caption from the alphabetical list c. Indent the captions for Direct Materials Used, Direct Labor, and Manufacturing Overhead. Use the increase Indent button on the Home tab in the Alignment section d. Complete the amounts to the right. Use the Excel function SUMO) to sum amounts on the schedule. e. Format the cells requiring dollar signs. 1. Format underlines or double underlines as needed. g. Boldface the total. (Always use coll references and formulas where appropriate to receive full credit.)
