With this format plaese using the options i clicked on. Thank you in advance.

TUNUCL SCE CRITICAL THINKING > Using Excel P16-41 Using Excel to classify manufacturing costs and to determine the cost of manufactured products, Download an Excel template for this problem online in MyAccountingLab or at http://www.pearsonhighered.com/Horngren. 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 Requirements 1. Use Excel to classify the costs a. Classify the costs as either period costs or product costs. 1. 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. I. To identify the classification, click in the cell. A drop down arrow will appear to the right click the arrow. If its a product cost, select direct materials, direct labor, or manufacturing overhead. If it's a period cost, select expense. 2. 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. a. Complete the heading b. To select the correct report caption, click in the cell. A drop 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. B Requirement 2: Complete the Schedule of Cost of Goods Manufactured. Fremont Troll House Cookies Schedule of Cost of Goods Manufactured Month endede March 31, 2018 I Beginning Work-in-Process Inventory Cost of Goods Manufactured Direct Labor Direct Materials Used Ending Work-in-Process Inventory Manufacturing Overhead Total Manufacturing Costs incurred during Period Total Manufacturing Costs to Account For