Suppose a government has to make the following payments to another government, in perpetuity.

• The first payment is made on 1 July 2020, and is equal to $1 million;
• All subsequent payments are made on the first of each month, but increasing at an inflation rate of 1% every 3 months.
• That is, the payments on 1 August and 1 September are also $1 million each, but the payments on 1 October, 1 November, and 1 December 2020 are $1.01 million each, the payment on 1 January 2021 is equal to $1,020,100, and so on.

1. Assuming an interest rate of 0.25% per annum, and including the value of the payment just made on 1 September 2079, use Excel to calculate the accumulated value of the above payments as at 1 September 2079. DO NOT hand in any excel workings.

Answer: ___________________________________ [2 marks]

2. Complete the 8 missing entries labelled ‘?’ in the following table, using your cashflow projection from Excel.– just complete the table below. [8 marks]

3. Suppose that the inflation rate is now not 1% per quarter at the end of each quarter, but 4% once per year, at the end of each year ending 1 July. Describe how you expect this to change your answer to (a) – does it increase, decrease, or stay the same? Give a reason for your answer. [2 marks]

4. The government making these payments is now concerned about a rapidly changing economic environment. It now expects inflation to be 1.555% per quarter, and interest rates to be 4.25% per year. What now is the accumulated of the above payments as at 1 September 2079? Give your answer to the nearest $million. [you do not need to show working, and DO NOT hand in any excel workings] [2 marks]

please use excel to do it. it also need to come with formula. formula is very important. many many thanks.

1. Prepare a sales budget for January through March and for the Quarter in total. The selling price per unit is $50.00.

December of the previous year           20,000

January                                     100,000

February                                   80,000

March                                       60,000

April                                         40,000

2. Prepare a purchases budget and the schedule for Disbursements for Purchases for January through March and for the first quarter in total. Assume that the company only sells one product that can be purchased at $35.00 per unit. The market for this product is very competitive and customers highly value quality and on time delivery of the product. Also assume that currently it is company policy that ending inventory should equal 50% of next month’s projected sales.

3. Prepare a cash budget for January through March and for the first quarter in total. The company maintains a minimum cash balance of $70,000.00, and this was the balance in the cash account on January 1. Past experience shows that 40% of sales are collected in the month of the sale, and 60% in the month following the sale. Selling cost is $12 per unit sold. Other expenses include $35,000 per month for rent, $104,000 for advertising, and $76,000 per month for depreciation. All costs are paid in the current month except inventory purchases, which are paid in the month following the purchase (i.e. January purchases of inventory are paid in February). The company has an open line of credit with a bank and can borrow at an annual rate of 12%. For simplification assume that all loans are made at the beginning of the month when a borrowing need is identified and repayments are made at the end of a month if there is enough cash to make the payment. Also, interest associated with a loan is only paid at the time when that loan is paid (i.e. a loan is only paid if there is enough cash to pay off the whole loan, any interest associated with it and still have enough cash left over for the minimum cash balance.)

Suppose a government has to make the following payments to another government, in perpetuity.

• The first payment is made on 1 July 2020, and is equal to $1 million;
• All subsequent payments are made on the first of each month, but increasing at an inflation rate of 1% every 3 months.
• That is, the payments on 1 August and 1 September are also $1 million each, but the payments on 1 October, 1 November, and 1 December 2020 are $1.01 million each, the payment on 1 January 2021 is equal to $1,020,100, and so on.

1. Assuming an interest rate of 0.25% per annum, and including the value of the payment just made on 1 September 2079, use Excel to calculate the accumulated value of the above payments as at 1 September 2079. DO NOT hand in any excel workings.

Answer: ___________________________________                                               [2 marks]

2. Complete the 8 missing entries labelled ‘?’ in the following table, using your cashflow projection from Excel.– just complete the table below.                     [8 marks]

3. Suppose that the inflation rate is now not 1% per quarter at the end of each quarter, but 4% once per year, at the end of each year ending 1 July. Describe how you expect this to change your answer to (a) – does it increase, decrease, or stay the same? Give a reason for your answer.                                                                                                                                     [2 marks]

4. The government making these payments is now concerned about a rapidly changing economic environment. It now expects inflation to be 1.555% per quarter, and interest rates to be 4.25% per year. What now is the accumulated of the above payments as at 1 September 2079? Give your answer to the nearest $million. [you do not need to show working, and DO NOT hand in any excel workings]     [2 marks]

Luzadis Company makes furniture using the latest automated technology. The company uses a job-order costing system and applies manufacturing overhead cost to products on the basis of machine-hours. The predetermined overhead rate was based on a cost formula that estimates $1,615,000 of total manufacturing overhead for an estimated activity level of 85,000 machine-hours.

During the year, a large quantity of furniture on the market resulted in cutting back production and a buildup of furniture in the company’s warehouse. The company’s cost records revealed the following actual cost and operating data for the year:

Required:

1. Compute the underapplied or overapplied overhead.

2. Assume that the company closes any underapplied or overapplied overhead to Cost of Goods Sold. Prepare the appropriate journal entry.

3. Assume that the company allocates any underapplied or overapplied overhead proportionally to Work in Process, Finished Goods, and Cost of Goods Sold. Prepare the appropriate journal entry.

4. How much higher or lower will net operating income be if the underapplied or overapplied overhead is allocated to Work in Process, Finished Goods, and Cost of Goods Sold rather than being closed to Cost of Goods Sold?

Assume that the company allocates any underapplied or overapplied overhead proportionally to Work in Process, Finished Goods, and Cost of Goods Sold. Prepare the appropriate journal entry. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.)

Assume that the company closes any underapplied or overapplied overhead to Cost of Goods Sold. Prepare the appropriate journal entry. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.)

Compute the underapplied or overapplied overhead.

How much higher or lower will net operating income be if the underapplied or overapplied overhead is allocated to Work in Process, Finished Goods, and Cost of Goods Sold rather than being closed to Cost of Goods Sold?

FIFO Perpetual Inventory

The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows:

Required:

1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 3, using the first-in, first-out method. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Goods Sold Unit Cost column and in the Inventory Unit Cost column.

2. Determine the total sales and the total cost of goods sold for the period. Journalize the entries in the sales and cost of goods sold accounts. Assume that all sales were on account.

3. Determine the gross profit from sales for the period. $

4. Determine the ending inventory cost as of June 30. $

5. Based upon the preceding data, would you expect the ending inventory using the last-in, first-out method to be higher or lower?

Which of the following is most likely to restore an economy to full employment, if it is operating below full employment due to a decrease in net exports?

Select one:

a. Devaluation of the domestic currency

b. None of these

c. A decrease in investment in the economy

d. A decrease in the demand for goods and services in the economy

e. An increase in the interest rate

How would offshoring production affect the composition of goods produced, and the relative wages between high-skilled and low skilled labor in home and foreign countries. What are the causes of wage polarization in the US and what kind of jobs are the most and the least vulnerable to outsourcing/offshoring?

*Please type the answers, Thank you!*

home / study / business / accounting / accounting questions and answers / the jarrad corporation's management team is getting ready to prepare its master budget for ...

Your question has been answered

Let us know if you got a helpful answer. Rate this answer

Question: The Jarrad Corporation's management team is getting ready to prepare its master budget for one it...

The Jarrad Corporation's management team is getting ready to prepare its master budget for one its product lines for the year 2019. The company produces caramel lollipops which are basically cooked down sugar on a stick, a diabetics nightmare along with many other sweet treats.

Budgeted sales of the lollipops for each quarter of 2019 are as follows:

1st Quarter-12,500 cases

2nd Quarter-14,000 cases

3rd Quarter-25,500 cases

4th Quarter-34,900 cases

There are 100 lollipops in a case and each sells for $200. Jarrad is budgeting a 5% sales price increase effective July 1,2019

The 4th Quarter 2018 sales have been budgeted at 32,000 cases and Jarrad wants to have an ending inventory carried over into 2019 of 2,000 cases.

At the end of 2019 they desire an ending inventory of 2,250 cases. Each quarter an additional 10% of that quarter's sales is to be produced as an ending inventoy to be carried over into the following quarter.

Materials:

Sugar costs the company $3.20 per lb. (16 ounces) Each lolllipop is 2 ounces of sugar which is melted down into caramel. The caramel is coated in 2 ounces of Belgian chocolate which costs the company $.28 per ounce. Each lollipop stick costs $.03

Direct Labor and Machine Hours:

The production of these lollipops is a highly automated one requring only 45 minutes to produce one case of lollipops. Of this 45 minutes, 30 minutes are automated and 15 minutes requires human interaction. The cost of running the machines during the year based on 4,500 hours is $8.75 per hour. Budget these hours evenly over the four quarters of 2019. The direct labor rate per hour is $11. The budgeted cost of operating the machinery is included in the manufacturing overhead budget for the year.

-What is the budgeted amount of sales revenues for 2019?

1st Quarter $.......................................

2nd Quarter $.....................................

3rd Quarter $......................................

4th Quarter $......................................

Total Budgeted Sales for 2019 $...............................................................