i need help with all requirements.

Uuing Excel to calculate a predetermined overhead allecation rate, journalite and post manutacturing journal entries, and adjust for overallocated or underallocated overhead, The company manufactures three whecled bikes for adultr. The company allocates manufacturing overhewd based on machine hours. Cedar River expects to incur $250,000 of manulacturing overhead costs, and to use 10,500 machine hours during fiscal year 2024, Cedar River reported the following inventories at May 31,2024 : During hune, 2024, Cedar fiver actually used 1,200 machine hours. 10 Use the blue shoded oreos on the ENTERANSWERS tabs for inputs. AlWAYS use cell references and formulas where appropsiate to receive full credit. If you copy/paste from the Instructions fab you will be marked wrong. Enter all amounts as positive values. Do not use a mines sign or pareatheses for any values. Requirements: 1 Compute the predetermined overhead allocation rate for 2024 . Use the blue shaded areas for inputs. 2. Ure Excol to journalize the transactions in the general journal. The account eitles are available whien you clek the down-arrow. Use the increase indent buthon on the Home tab to indent ilems: 3. Pout the transactions to T-accounts. The balances in the T-accodints are automutically ugdated. Enter the beginnirs balances for the inventories. Assume the rest of the atcounts have beginning balances of zero. A Adult the manulacturing overhead account. a. Prepare the purnalentry: b. Post to T-accounts. unt the ending balances far flaw Materials leventury, Woek in Process inventory, Finished Goods Inventory, and Cost af - Coods Sold. 6. Complete the seredule af Cost of Goads Manuftctured foe bune 2024. 7 Complein the Cost of Goods Sald sthedule for hune 2024. Compute the predetermined overhead allocation rate for fiscal year 2024. (Always use cell references and formulas where appropriate to recene full credit. If you copy/paste from the instructions tab you wrong. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values. 4 4 Post the transactions. The balances in the T-accounts are automatically updated. Enter the beginning balances for the inventories. Assume the rest of the accounts have beginning balances of zero (do not enter zero as the beginning balances). (Ahways use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values. List the endina balances for Raw Materials Inventory, Work-in.Process Inventory, Finished Goods inventory, and Cost of Goods Sold. (Always use cell references and formulas where appropriate to receive full credit. Enter all amounts as positive values. Do not use a minu. or parentheses for any values.) Cell I Hint: C.8:C9 3 in the appopriate cells, begin the formula with an equal sign (a),and use cellil references to the ENIERNNWWERS Lab 10 calsulate the ampunt of adjusting entry. Do not refer to the ending balance cells in your calculations. 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 positive numbers.) Schedule of Cost of Goods Manufactured Al values other than the value for Ending Work-in-9rocess inventory should be entered as positive values. Use minas sien to enter the value for Lnding Work-in-Process inventory: Cell I Hant: [10, D11:D13, F16,C25 I Use the numeric values fram the instructions tab for calculations, Do not use an equal aign (=) when entering a single numeric value. t.14 | Uhe the sUMAI function to calcutate the total manufacturing costs incuered during period