The country has an initiative for students in underperforming schools. To get funding, schools provide each student with eight 2-hour-long group teachering sessions each month. Also, parents must agree to pay $10 per month for each child they register for the program. The county will pay each school $200 per enrolled child, per month.

Schools must provide one teacher for every five students enrolled in the program, at a cost of

$50 per hour at a teacher’s home school, or $60 per hour if the teacher has to commute from another school in the system.

Schools that participate also need to acquire a site license for a self-study computer program, at a cost of $2,400 per year regardless of the number of students. The school also incurs a cost of $1.50 per child, per teachering session, for workbooks that are tied to the self-study program.

Generally, the county takes one month to pay bills submitted by schools. Parents pay all tuition bills at the beginning of each month. Participating teachers are paid for all after-school programs at the end of each month. The full cost of the software must be paid by the end of the first month of the program. Workbooks are paid for in the month they are used.

You are the budget manager for Typical County School (TCS). Five teachers in your school have agreed to be teachers. Since you expect to need 15 teachers by the end of the year, you will also use 10 teachers from other schools, as needed. Your calculations indicate an expected 25 students in the program during the first month it is offered. 41 in the second month and 52 in the third month. As budget manager:

1. Prepare operating budgets for each of the first three months of the program.
2. Summarize the three monthly budgets into a quarterly operating budget
3. Starting from a zero cash-balance, prepare a cash budget for the first quarter (three months) of the program. You do not have to prepare monthly cash budgets.

Cost of Goods Sold

Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts that 54,200 units will be produced, with the following total costs:

Next year, Pietro expects to purchase $116,000 of direct materials. Projected beginning and ending inventories for direct materials and work in process are as follows:

Pietro expects to produce 54,200 units and sell 53,500 units. Beginning inventory of finished goods is $39,500, and ending inventory of finished goods is expected to be $31,000.

Required:

1. Prepare a statement of cost of goods sold in good form.

2. What if the beginning inventory of finished goods decreased by $3,000? What would be the effect on the cost of goods sold?

• increase
• decrease
• no change

by $

George Young Industries (GYI) acquired industrial robots at the beginning of 2018 and added them to the company’s assembly process. During 2021, management became aware that the $2.8 million cost of the equipment was inadvertently recorded as repair expense on GYI’s books and on its income tax return. The industrial robots have 10-year useful lives and no material salvage value. This class of equipment is depreciated by the straight-line method for financial reporting purposes and for tax purposes it is considered to be MACRS 7-year property. Cost deducted over 7 years by the modified accelerated recovery system as follows:

The tax rate is 25% for all years involved.

Required:
1. & 3. Prepare any journal entry necessary as a direct result of the error described and the adjusting entry for 2021 depreciation.
2. Will GYI account for the change (a) retrospectively or (b) prospectively?

Net Present Value of Payouts The NPV of a series of values is calculated using a discount rate applied to those values. Apply the NPV function to the series of expected benefit payouts using .075 as the discount rate. You can hard-code the discount rate. How would you calculate this in Excel? Please show calculation and logic used in excel, so I understand. Below are the values:

These financial statement items are for Ivanhoe Company at year-end, July 31, 2022.

1. Prepare an income statement for the year. Ivanhoe Company did not issue any new stock during the year. (Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).)

2. Prepare a retained earnings statement for the year. Ivanhoe Company did not issue any new stock during the year.

3. Prepare a classified balance sheet at July 31. (List Current Assets in order of liquidity.)

On January 1, 2020, Flounder Company purchased 11% bonds, having a maturity value of $320,000 for $344,893.28. The bonds provide the bondholders with a 9% yield. They are dated January 1, 2020, and mature January 1, 2025, with interest received on January 1 of each year. Flounder Company uses the effective-interest method to allocate unamortized discount or premium. The bonds are classified as available-for-sale category. The fair value of the bonds at December 31 of each year-end is as follows.

(Round answers to 2 decimal places, e.g. 2,525.25. Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)

Example Five:

On January 1, 2018, OP Company purchased equipment to be used in their business. The equipment cost $78,000. It will be used for 8 years, after which its salvage value (residual value) is estimated to be $6,000.

Required:

1. Record the purchase of the machine on January 1, 2017.

2. Complete the depreciation table below using straight-line depreciation.

Record the depreciation expense as of December 31, 2018.

Suppose OP Company sells the equipment on December 31, 2021 for $44,000. Prepare the journal entry to record the sale.

The following table lists the cross elasticity of demand for several goods, where the percentage quantity change is measured for the first good of the pair, and the percentage price change is measured for the second good.

Good Cross elasticity of demand

Air-conditioning units and kilowatts of electricity -0.34

Coke and Pepsi 0.63

High-fuel-consuming SUVs and gasoline -0.28

McDonald’s burgers and Harvey burgers 0.82

Butter and Margarine 1.54

1.Explain the sign of each of the cross elasticities. What does it imply about relationship between the two goods in questions.

2. Compare the absolute value of the cross elasticities and explain their magnitudes. For example, why is the cross elasticity of demand of McDonald’s burgers and Harvey’s burgers less than cross elasticity of butter and margarine?

3. Use the information in the table to calculate how a 5% increase in the price of Pepsi affects the quantity of Coke demanded.

4. Use the information in the table to calculate how a 10% decrease in the price of gasoline affects the quantity of SUVs demanded