During the 2018 financial year, Foster Manufacturing recorded the following income and expenditure. GST is not considered in this question. • Sales Revenue of $2,040,000
• Operating Expenses of $322,000
• Income tax Expense $215,000

Charges to Production were:
• Raw Materials issued to Production of $420,000
• Direct labour charged to Production $340,000
• Overheads charged to Production $272,000
• Actual cost of Overheads $265,000

Additional Information:
• Work in Process at the beginning of the period was $102,000
• Work in Process at the end of the period was $110,000
• Finished Goods at the beginning of the period was $234,000
• Finished Goods at the end of the period was $252,000

Required:
Based on the transactions recorded, within Microsoft Excel prepare a:
Cost of Goods Sold Statement

Amanda rice has just arranged to purchase a $640,000 vacation home in the bahamas with a 20 percent down payment. the mortgage has a 7 percent apr compounded monthly and calls for equal monthly payments over the next 30 years. her first payment will be due one month from now. however, the mortgage has an eight-year balloon payment, meaning that the balance of the loan must be paid off at the end of year 8. there were no other transaction costs or finance charges. how much will amanda’s balloon payment be in eight years

Companies in the u.s. car rental market vary greatly in terms of the size of the fleet, the number of locations, and annual revenue. in 2011 hertz had 320,000 cars in service and annual revenue of approximately $4.2 billion. the following data show the number of cars in service (1000s) and the annual revenue ($ millions) for six smaller car rental companies (auto rental news website, august 7, 2012). excel file: data14-09.xls if required, enter negative values as negative numbers. a. select a scatter diagram with the number of cars in service as the independent variable. b. what does the scatter diagram developed in part (a) indicate about the relationship between the two variables? c. use the least squares method to develop the estimated regression equation (to 3 decimals). ŷ = + x d. for every additional car placed in service, estimate how much annual revenue will change. by $ e. fox rent a car has 11,000 cars in service. use the estimated regression equation developed in part (c) to predict annual revenue for fox rent a car. round your answer to nearest whole value. $ million hide feedback partially correct

On january 15, the end of the first biweekly pay period of the year, north company’s payroll register showed that its employees earned $32,000 of sales salaries. withholdings from the employees’ salaries include fica social security taxes at the rate of 6.2%, fica medicare taxes at the rate of 1.45%, $3,000 of federal income taxes, $772 of medical insurance deductions, and $260 of union dues. no employee earned > $7,000 in this first period. prepare the journal entry to record north company’s january 15 (employee) payroll expenses and liabilities.