It’s work related math

Sheet1
    Student #    11901677        Step 1: Select your student number from the drop down list
    Sachita    KHATRI        Step 2: Check your Name to ensure you have selected your student number correctly
    Important: The file should be opened in Excel            Step 3: Download or print the question and prepare your answers in a Word file and save
    Different questions for each student, check your name and ID carefully            Step 4: Upload your answer on Moodle submission Link before the Due date and time
    Assignment question
    Sami Design Ltd manufactures Sami musical instruments for use by high school students. The company uses a job costing system in which manufacturing overhead is applied on the basis of direct labour hours. The company’s budget for the current year included the following predictions:
    Budgeted total manufacturing overhead    $450,800                                            450800            $426,300
    Budgeted total direct labour hours     22540                                            22,540            20300
    During March, the firm began two production jobs:
    job number T81, consisting of 80 trombones                                                 $80            76
    job number C40, consisting of 135 cornets.                                                $135            110
    The events of March are described as follows:
    1000 square metres of rolled Sami sheet metal were purchased on credit for $9000                                                1000    $9,000        1000    5000
    400kilograms of Sami tubing were purchased on credit for $6000                                                400    $6,000        400    4000
    The following requisitions were filed on 5 March:
    — requisition number 112: 250 square metres of Sami sheet metal @ $5 per square metre (for job number T81)                                                 250    $5        250    5
    — requisition number 113: 1000 kilograms of Sami tubing @ $10 per kilogram (for job number C40)                                                1000    $10        1000    10
    — requisition number 114: 10 litres of valve lubricant @ $1 per litre.                                                 10    $1        10    10
    — All Sami used in production is treated as direct material. Valve lubricant is an indirect material.
    An analysis of labour time sheets revealed the following labour usage for March:
    — direct labour: job number T81, 900 hours @ $20 per hour                                                 900    $20        800    20
    — direct labour: job number C40,1000 hours @ $20 per hour                                                1000    $20        900    20
    — indirect labour: general factory clean-up, $4000                                                $4,000            4000
    — indirect labour: factory supervisory salaries, $9000                                                $9,000            9000
    Depreciation of the factory building and equipment during March amounted to $12000                                                $12,000            12000
    Rent paid in cash for warehouse space used during March was $1200                                                $1,200            1200
    Electricity costs incurred during March amounted to $2100 The invoices for these costs were received, but the bills were not paid in March.                                                $2,100            2100
    March council rates and property taxes on the factory were paid in cash, $2400                                                $2,400            2400
    Insurance cost covering factory operations for March was $3100 The insurance policy had been prepaid in February.                                                $3,100            3100
    Costs of salaries and on-costs for sales and administrative personnel paid in cash during March amounted to $8000                                                $8,000            8000
    Depreciation on administrative office equipment and space amounted to $4000                                                $4,000            4000
    Other selling and administrative expenses paid in cash during March amounted to $1000                                                $1,000            1000
    Job number T81 was completed in March.
    Half the trombones in job number T81 were sold on credit during March for $900 each.                                                $900            700
    
    The 1 March balances in selected accounts are as follows:
    Account Name    1 March Balance
    Cash    $10,000                                            $10,000            10000
    Accounts Receivable    $21,000                                            $21,000            21000
    Prepaid Insurance    $7,200                                            $7,200            5000
    Raw material Inventory    $149,000                                            149000            149000
    Manufacturing supplies inventory    $500                                            500            500
    Work in process Inventory    $92,000                                            $92,000            91000
    Finished Goods Inventory    $276,000                                            $276,000            220000
    Accumulated depreciation: building and equipment    $102,000                                            102000            102000
    Accounts...