this is from managerial accounting chapter 2. it is done in excell. this is all the information i was provided so please do not ask for more. thank you!

all the information i was given to complete the problem is provided.

D E F G H 6,500 165 276 B 1 The number of conveyors produced by Movable Mandy Corporation the current year. 2 The number of conveyors in beginning inventory. 3 The number of conveyors in ending inventory. 4 5 The accounting records provided the following information: 6 Purchases of raw materials 850000 8 Beginning materials inventory 54,450 9 Ending materials inventory 93,840 10 Direct labor cost 956,000 11 Indirect labor cost 219,000 12 Rent on the factory building 36,000 13 Utilities on the factory building 12,000 14 Rent on the adminstration building 60,000 15 Utilities on the administration building 3,000 16 Administration salaries 345,000 17 Salespersons commissions 225,000 18 Salespersons auto expense 38,600 19 Office expense 4,800 20 Factory supples 22,000 21 Repairs on factory equipment 24,500 22 Repairs on office equipment 3,200 23 Insurance on factory building & equipment 3,900 24 Insurance on office building & equipment 2,200 25 Depreciation of factory equipment 46,000 26 Depreciation of office equipment 16,000 27 Beginning work in process inventory 31,000 28 Ending work in process inventory 42,000 29 Beginning finished goods inventory 61,050 30 Ending finished goods inventory 102,120 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 Information COGM COGS Income Statement Calculations + E G H J K M 1 2 3 B D Prepare a Cost of Goods Manufactured Statement using good formatting (Note: put the dollar signs in the narrow columns and be sure to use underline and double underline. Movable Mandy Corporation Schedule of Cost of Goods Manufactured Year ended December 31, 2020 6 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 Information COGM COGS Income Statement Calculations + F G H K B C D E 1 Prepare a Cost of Goods Sold Statement using good formatting 2 (Note: put the dollar signs in the narrow columns and be sure to use underline and double underline 3 Movable Mandy Corporation 5 Schedule of Cost of Goods Sold 6 Year ended December 31, 2020 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 Information COGM COGS Income Statement Calculations + A B D E F . 500 The selling price of the conveyors is: Prepare a Multi-step Income Statement using good formatting Movable Mandy Corporation Income Statement Year ended December 31, 2020 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 Information COGM COGS Income Statement Calculations + B D E F G H J C 1 Compute the folowing four items for Movable Mandy Corporation: (show your work) 3 1) The average cost of producing one unit of equipment for the year. 2 Round to nearest penny 4 5 6 7 2) The gross proft margin. Round to learest 0.00% 8 9 10 11 12 3) The prime costs 13 14 15 16 17 4) The conversion costs. 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 Information COGM COGS Income Statement Calculations +