Account Analys to Determine Behavior 1. Hins, wer of Robin's Nest was to determine the behavior of branded workers ang busytimes, everyone words to get the orders out. Temps temporary workers tured through an agency) may be hired to pack and record orders for the Dungere og tog drvetasks while the Salted workers de preventive manance, chan the lines and building Temperen bandung sowieso found that was to payment rentals and plant anderen deprecation are the west doar account. He believes that workers and plant and met de concentrated with the number of orders (income workers are red to pack and prepare completed orders for whit), and electricity with brown the summer ofteret ports stored by Robin's Nest exceeds the space in the materials toreroom, Hetty war crescento. Therefore, he wives warehouse payments are rate with the number of parts purchased and stored. The combines for the month them to Plant Workers Temp Agency Warehouse tipulgara | Salaries Payments Beta Flectricity Depreciation 57,500 SO 27 Funny 7.500 600 2.00 200 7.500 1.100 700 2.200 A 1.350 300 25 2,500 7,500 2.00 1.500 210 22 00 Total $45.000 100 SL710 3.600 1200 Information number of machine hours, randarts for the month and Machine Hours 2.000 Number of Orders Number of Parts 10 200 Number of Orders Number of Parts Machine Hours 2.000 2.100 10 200 January February 40 Mard 5.000 550 April 500 400 5200 570 190 Mary 6.900 350 June 6,000 30.000 1.60 Total 2.850 Required 1. Calculate the month overage count balance for each accountWhen required, round your answers to the nearest dollar and use your rounded answers in die sent computations. Average worries Averagem cment Average warehouse Age electricity Average deprecation Calculate the verge monthly amount for each of the thrersWhen required, round your answers to the nearest while her Average made her Average number of orders Average of Previous Ne Got the outchofth the drivers when your awers to the rest womer. man hours of parts 2. Chud mother les fortement where it does to the rest on the rounded in subsequent computations. Aege mayo Variable per order Vintable for wars rent per-machine.hor Vatte for Eres the results in the form of a cout Many cost . orden corta machar 3. In luy. Darnell predicts there will be 420 orders. 240, and machine hours. What is the brand that for computation to decimal place and round Tinal answer to the nearest della 4. What if new made inly for $34.0007 The main spected to last 10 years and will have not the end of time What to be fedted HOW Wits part of the cost to bend in sunt computation Average foed ronthly cost Vote formy Variable vote for warehouse Varbloeity Express the results in the form of a forte Code) Carta) Jonature tous Ove predict there we are 200 ports, and 5,000 achine tours What is the title and had cent for Hound interim computations to 1 encimal place and round final answer to the nearest dollar. Manthos + . what it tarmet buy a new machine in My Por $24,000) The mature s opected to last 10 years and win hawa na snage value 2 me end of the time what det er befected? w will the part of the contention beca? We new best when require round your answer to the nearest do 5. Stomperens based on the station they created the method days as they provide showing what appear the con involving the conted Therefore, he believes warehouse rental payment Workers' Salaries Temp Agency Payments Warehouse Rental Plant & Equipment Depreciation Electricity January $7,500 $0 $150 $275 $2,200 February 7,500 600 350 385 2,200 March 7,500 1,100 325 705 2,200 7,500 April 1,350 340 745 2,200 May 7,500 335 765 1,751 2,200 June 7,500 1,500 210 725 2,200 Total $45,000 $6,300 $1,710 $3,600 $13,200 Information on number of machine hours, orders, and parts for the six-month period follows: Machine Hours Number of Orders Number of Parts January 2,000 10 200 February 3,100 40 600 March 5,800 350 550 April 6,200 400 580 May 6,900 490 570 1. Calculate the monthly average account balance for each account. When required, round your answers to the nearest dollar and use you Average workers' salaries Average temp agency payment Average warehouse rental Average electricity Average depreciation Calculate the average monthly amount for each of the three drivers. When required, round your answers to the nearest whole number. Average machine hours Average number of orders I Average number of parts Accounting numeric field 2. Calculate fixed monthly cost and the variable rates for temp agency payments, warehouse rent, and electricity. If required, round your ans Average fixed monthly cost Variable rate for temp agency per order Variable rate for warehouse rental per part Variable rate for electricity per machine hour Express the results in the form of an equation for total cost. Monthly cost Corders) (parts) (machine hours) 3. In July, Darnell predicts there will be 420 orders, 240 parts, and 5,800 machine hours. What is the total labor and overhead cost for July? Rou bild dollar. Express the results in the form of an equation for total cost, Monthly cost Corders) parts) (machine hours) 3. In July, Darnell predicts there will be 420 orders, 240 parts, and 5, 800 machine hours. What is the total labor and overhead cast for July Round interim computati dollar. 4. What is Darnell buys a new machine in July for $24,000? The machine is expected to last 10 years and will have no salvage value at the end of that time. What part How will this part of the cost equation be affected? What is the new expected cont in July? When required, round your answer to the nearest dollar. 5. Students are asked to form a prediction or estimation of various costs based on the cost function they created using the method. Thus, their resulting estimates of various costs represent an example of data analytics as they provide useful inputs regarding what will happen finan