Personal Budget

At the beginning of the school year, Craig Kovar decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget:

a. Prepare a cash budget for September, October, November, and December. Use the minus sign to indicate cash outflows, a decrease in cash or cash payments.

b. What are the budget implications for Craig Kovar?

Craig can see that his present plan will not provide  sufficient cash. If Craig did not budget but went ahead with the original plan, he would be $__________ short  at the end of December, with no time left to adjust.

In 2001, a 3-year old boy was admitted to hospital in Mt Isa, Queensland with a two-day history of an acute febrile illness and convulsions. He remained febrile over the following two days. He had further brief seizures and then developed a left hemiparesis (paralysis of one side of the body), agitation and confusion, and subsequently became comatose. He was commenced on broad spectrum antibiotics and acyclovir. Two months later he had persisting major neurological sequelae, and remained semi-comatose with a spastic quadriplegia. In a provisional diagnosis of acute encephalitis, what viral etiologic agent is likely?

Select one:

a. Japanese encephalitis virus.

b. West Nile encephalitis virus.

c. St Louis encephalitis virus.

d. Murray Valley encephalitis virus.

Consider a 30-year mortgage for $137018 at an annual interest rate of 3.9%. What is the remaining balance after 19 years? Round your answer to the nearest dollar.

The WalMart’s fiscal year starts the first week of February. This means that when analyzing the data, week 26 is actually week 30 (26+4 weeks for January) in 2002 or the end of July 2002. Also, week 52 is actually week 4 (52+4 weeks for January 2002 minus 52 weeks for 2002) in 2003 or the end of January 2003. As an example, the spike in sales (revenue) at week 75 occurs in week 27 (75+4 weeks for January 2002 minus 52 weeks for 2002) in 2003 or the first week in July 2003. This corresponds to sales for the July 4th holiday when people are buying barbecue related items. Please use excel.

Identify spikes (outliers) in the data where extreme sales values occur and correlate these spikes with actual calendar dates in 2002 or 2003 and with holidays or special events that may occur during these periods.

1. Modeling the data linearly - a. Generate a linear model for this data by choosing two points.

b. Generate a least squares linear regression model for this data.

c. How good is this regression model? Output and discuss the R² value.

d. What are the marginal sales (derivative, i.e. rate of change) for this department using the linear model with two data points and the regression model?

e. Compare the two models. Which do you feel is better?

f. Remove appropriate outliers as you deem necessary and rerun the linear regression model. What is the marginal sales and discuss improvements.

2. Modeling the data quadratically - a. Generate a quadratic model for this data. Also output and discuss the R² value.

b. What are the marginal sales for this department using this model?

c. Calculate the model generated relative max/min value. Show backup analytical work.

d. Compare actual and model generated relative max/min value.

e. Remove outliers and rerun the quadratic least squares model. What is the marginal sales and discuss improvements.

3. Comparing models - a. Based on all models run, which model do you feel best predicts future trends? Explain your rationale.

b. Based on the model selected, what type of seasonal adjustments, if any, would be required to meet customer needs?

The WalMart’s fiscal year starts the first week of February. This means that when analyzing the data, week 26 is actually week 30 (26+4 weeks for January) in 2002 or the end of July 2002. Also, week 52 is actually week 4 (52+4 weeks for January 2002 minus 52 weeks for 2002) in 2003 or the end of January 2003. As an example, the spike in sales (revenue) at week 75 occurs in week 27 (75+4 weeks for January 2002 minus 52 weeks for 2002) in 2003 or the first week in July 2003. This corresponds to sales for the July 4th holiday when people are buying barbecue related items. Please use excel.

Identify spikes (outliers) in the data where extreme sales values occur and correlate these spikes with actual calendar dates in 2002 or 2003 and with holidays or special events that may occur during these periods.

1. Modeling the data linearly - a. Generate a linear model for this data by choosing two points.

b. Generate a least squares linear regression model for this data.

c. How good is this regression model? Output and discuss the R² value.

d. What are the marginal sales (derivative, i.e. rate of change) for this department using the linear model with two data points and the regression model?

e. Compare the two models. Which do you feel is better?

f. Remove appropriate outliers as you deem necessary and rerun the linear regression model. What is the marginal sales and discuss improvements.

2. Modeling the data quadratically - a. Generate a quadratic model for this data. Also output and discuss the R² value.

b. What are the marginal sales for this department using this model?

c. Calculate the model generated relative max/min value. Show backup analytical work.

d. Compare actual and model generated relative max/min value.

e. Remove outliers and rerun the quadratic least squares model. What is the marginal sales and discuss improvements.

3. Comparing models - a. Based on all models run, which model do you feel best predicts future trends? Explain your rationale.

b. Based on the model selected, what type of seasonal adjustments, if any, would be required to meet customer needs?

DataSpan, Inc., automated its plant at the start of the current year and installed a flexible manufacturing system. The company is also evaluating its suppliers and moving toward Lean Production. Many adjustment problems have been encountered, including problems relating to performance measurement. After much study, the company has decided to use the performance measures below, and it has gathered data relating to these measures for the first four months of operations.

Management has asked for your help in computing throughput time, delivery cycle time, and MCE. The following average times have been logged over the last four months:

Required:

1-a. Compute the throughput time for each month. (Round your answers to 1 decimal place.)

1-b. Compute the manufacturing cycle efficiency (MCE) for each month. (Round your answers to 1 decimal place.)

1-c. Compute the delivery cycle time for each month. (Round your answers to 1 decimal place.)

3-a. Refer to the move time, process time, and so forth, given for month 4. Assume that in month 5 the move time, process time, and so forth, are the same as in month 4, except that through the use of Lean Production the company is able to completely eliminate the queue time during production. Compute the new throughput time and MCE. (Round your answers to 1 decimal place.)

3-b. Refer to the move time, process time, and so forth, given for month 4. Assume in month 6 that the move time, process time, and so forth, are again the same as in month 4, except that the company is able to completely eliminate both the queue time during production and the inspection time. Compute the new throughput time and MCE. (Round your answers to 1 decimal place.)

This is a Discussion Issue

A nonprofit organization has a 30-year, 5% mortgage on a existing building. The mortgage requires a $3,000 monthly payment. Their current bookkeeper is preparing financial statements for the board and, in doing so lists the mortgage balance at $287,000 under the current liabilities because the board hopes to be able to pay off the mortgage in full next year. Of the mortgage principle, $20,000 will be paid next year if the organization pays according to the mortgage agreement. The board members call you, their trusted CPA, to advise them on how should they report the mortgage on the balance sheet.

Question:

1. What might be an ethical issue here?

2. What would you recommend, leave as is or change the financial statement.

In addition, there is a 200 word minimum for your initial post.

Consider this type of growth: On balanced growth path, an economy grows at 1.8% a year. 0.8% comes from population growth and 1% comes from technology improvement. What are the rates of change of the variables?

1. Number of workers? 2. Rate of depreciation? 3. Output per worker? 4. Volume of capital? 5. Savings rate?