Provide an example of how businesses might apply a conditional formula to spreadsheet data

Assume that the following conditions exist: a. all banks are fully loaned up- there are no excess reserves, and desired excess reserves are always zero. b. the money multiplier is 5 .     c. the planned investment schedule is such that at a 4 percent rate of interest, investment =$1450 billion. at 5 percent, investment is $1420 billion. d. the investment multiplier is 3 . e.. the initial equilibrium level of real gdp is $12 trillion. f. the equilibrium rate of interest is 4 percent now the fed engages in contractionary monetary policy. it sells $1 billion worth of bonds, which reduces the money supply, which in turn raises the market rate of interest by 1 percentage point. calculate the decrease in money supply after fed's sale of bonds: $nothing billion.

An important application of regression analysis in accounting is in the estimation of cost. by collecting data on volume and cost and using the least squares method to develop an estimated regression equation relating volume and cost, an accountant can estimate the cost associated with a particular manufacturing volume. consider the following sample of production volumes and total cost data for a manufacturing operation. production volume (units) total cost ($) 400 4000 450 5000 550 5400 600 5900 700 6400 750 7000 compute b 1 and b 0 (to 2 decimals if necessary). b 1 b 0 complete the estimated regression equation (to 2 decimals if necessary). = + x what is the variable cost per unit produced (to 1 decimal)? $ compute the coefficient of determination (to 4 decimals). note: report r 2 between 0 and 1. r 2 = what percentage of the variation in total cost can be explained by the production volume (to 2 decimals)? % the company's production schedule shows 500 units must be produced next month. what is the estimated total cost for this operation (to 2 decimals)? $

Required information problem 15-1a production costs computed and recorded; reports prepared lo c2, p1, p2, p3, p4 [the following information applies to the questions displayed below. marcelino co.'s march 31 inventory of raw materials is $84,000. raw materials purchases in april are $540,000, and factory payroll cost in april is $364,000. overhead costs incurred in april are: indirect materials, $59,000; indirect labor, $26,000; factory rent, $38,000; factory utilities, $19,000; and factory equipment depreciation, $58,000. the predetermined overhead rate is 50% of direct labor cost. job 306 is sold for $670,000 cash in april. costs of the three jobs worked on in april follow. job 306 job 307 job 308 balances on march 31 direct materials $30,000 $36,000 direct labor 25,000 14,000 applied overhead 12,500 7,000 costs during april direct materials 133,000 210,000 $100,000 direct labor 105,000 150,000 101,000 applied overhead ? ? ? status on april 30 finished (sold) finished in process (unsold) required: 1. determine the total of each production cost incurred for april (direct labor, direct materials, and applied overhead), and the total cost assigned to each job (including the balances from march 31). a-materials purchases (on credit). b-direct materials used in production. c-direct labor paid and assigned to work in process inventory. d-indirect labor paid and assigned to factory overhead. e-overhead costs applied to work in process inventory. f-actual overhead costs incurred, including indirect materials. (factory rent and utilities are paid in cash.) g-transfer of jobs 306 and 307 to finished goods inventory. h-cost of goods sold for job 306. i-revenue from the sale of job 306. j-assignment of any underapplied or overapplied overhead to the cost of goods sold account. (the amount is not material.) 2. prepare journal entries for the month of april to record the above transactions. 3. prepare a schedule of cost of goods manufactured. 4.1 compute gross profit for april. 4.2 show how to present the inventories on the april 30 balance sheet.