please dont do the first 2 ones...need help with these 4 questions

the first one

Advertising department expenses of $75,000 and purchasing department expenses of $58,300 of Cozy Bookstore are allocated to operating departments on the basis of dollar sales and purchase orders, respectively. Information about the allocation bases for the three operating departments follows Purchase Orders 1,680 945 875 3,500 $150.000 84, 66.600 5200,00 ber Total Complete the following table by allocating the expenses of the two service departments (advertising and purchasing) to the three operating departments Complete this question by entering your answers in the tabs below. Marciano EXP Mies of Sery Dent Complete the following table by allocating the expenses of the two service departments advertising and purchasing to the three operating departments. Allocation Base Percent of Allocation Base Cost to be Allocated on Cost Numerator Denominator of Total Advertisi Deparmene Socks Mais Newsers To Pune Allocation Base Percent of Allocation Bar Co to be located Allocated cost Numero SORE MA New TOUS Advertising department expenses of $75,000 and purchasing department expenses of $58,300 of Cozy Bookstore are allocated to operating departments on the basis of dollar sales and purchase orders, respectively. Information about the allocation bases for the three operating departments follows riders S350, Books Magazines Nopers Total 66, $ 200, 3, see Complete the following table by allocaung the expenses of the two service departments (advertising and purchasing to the three operating departments Complete this question by entering your answers in the tabs below. Allocation or ser E De Complete the spreadsheet by afocating the expenses of the two service departments (advertising and purchasing) to the three operating departments Amounts to be deducted should be indicated with min COZY BOOKSTORE Departmental Expense Allocation Spreadsheet Expense Totals Advertising Purchaung Books Man News detent penses 333.000 36.000 53001 $174.000 $ 160,800 S358.200 Expenses S. 22.000 AKEP Exercise 22.4 Indirect payroll expense allocated to departments LO P2 Jessica Porter works in both the Jewelry department and the cosmetics department of a retail store. She assists customers in both departments and arranges and stocks merchandise in both departments. The store allocates her $28.600 annual wages between the swo departments based on the time worked in the two departments in each two-week pay period. On average, Jessica reports the following hours and activitas spent in the two departments vities Selling in jewelry department Ananging and stocking merchandise in jewelry department Selling in cosmetic department Arranging and stocking merchandise In cosmetics department Idle time spent waiting for customer to enter one of the departients Hours 49. 10.0 16.0 11.0 8.0 Allocate Jessica's annual wages between the two departments. Departem House Wages Allocation Percent of Hours worked Numerator Denominator of Hours ewelry Cosmetics TAS apter 22 Homework 4 Exercise 22.210 Assigning Joint real estate costs LO C3 Heart & Home Properties is developing a subdivision that includes 300 home lots. The 240 lots in the Canyon section are belowa ridge and do not have views of the neighboring canyons and hills: the 60 lots in the Hilltop section offer unobstructed views. The expected selling price for each Canyon lot is $48,000 and for each Hilltop lot is $92,000. The developer acquired the land for $1.800.000 and spent another $1700,000 on street and utilities Improvements Assign the joint land and improvement costs to the lots using the value basis of allocation and determine the average cost per lot Do not round your Intermediate calculations.) MERELVA Pere Market Value Cost to locate Allocated Cast Quantity Average Lot of Lots Dost Numerator Denominator of Me Value Canyon Section Hilltop section Total Exercise 22-5 Departmental expense allocations LO P2 Woh Che Co. has four departments: Materials, Personnel, Manufacturing, and Packaging. In a recent month, the four departments Incurred three shared Indirect expenses. The amounts of these Indirect expenses and the bases used to allocate them follow. Indikt Expense Cast Allocation Base Supervision $ 82,800 Number of employees utilities 53. Square feet occupied 24.ee value of assets in use Total $199, Insurance Departmental data for the company's recent reporting period follow. Department Materials Promet Manufacturing Packaging Total Employees 28 2 63 42 Square Feet 39.869 6,5 65, 19,5 130, cea Asset Values $12,600 3,150 31,50 15.250 563.000 1. Use this information to allocate each of the three Indirect expenses across the four departments 2. Prepare a summary table that reports the Indirect expenses solgned to each of the four departments Complete this question by entering your answers in the tabs below. od 1 than information to alocate each of the three indirect expenses across the fout departments Bupervision expancat Allocation Baca Cost to be Allocated Allocated Cott Percent of Aligation Bach Tot Porto TUTORITA LG $12 3.150 5, nufacturing Pack Metal 140 15.25 $63, 1 Use this information to allocate each of the three Indirect expenues across the four departments 2. Prepare a summary table that reports the Indirect expenues nesigned to each of the four departments, Complete this question by entering your answers in the tabs below. Rad Toured Like this information to allocate each of the three indired expenses across the four departments TV Action e Abouton Bea cos Descoles Department Numerator Denominato of Total Parsonna Manuteng Fang Tata Alocation Bach God to be AlloCost Percent of Allboaba EAC Numerenom Ciecare Personas Naran To Faroen Aontan bot be Atondo Cost Alia Bho incur SA M. Facing TO 29 Materials Personnel Manufacturing Packaging Total 63 42 140 39, 6,500 65.ee 19, see 138,eee $12,680 3,150 31,500 15,750 $63,eee 1. Use this information to allocate each of the three Indirect expenses across the four departments. 2. Prepare a summary table that reports the Indirect expenses assigned to each of the four departments. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a summary table that reports the Indirect expenses assigned to each of the four departments. Bupervision antes Incurance Total Mataras 0 0 Personnel 0 Manufacturing Packaging Totals O 0 $ 5 0 5 DS