Exercise 10-31 Cash Receipts and Payments [LO 10-4] Information pertaining to Noskey Corporation’s sales revenue follows: November 2018 (Actual) December 2018 (Budgeted) January 2019 (Budgeted) Cash sales $ 115,000 $ 121,000 $ 74,000 Credit sales 282,000 409,000 208,000 Total sales $ 397,000 $ 530,000 $ 282,000 Management estimates 5% of credit sales to be uncollectible. Of collectible credit sales, 60% is collected in the month of sale and the remainder in the month following the month of sale. Purchases of inventory each month include 70% of the next month’s projected total sales (stated at cost) plus 30% of projected sales for the current month (stated at cost). All inventory purchases are on account; 25% is paid in the month of purchase, and the remainder is paid in the month following the month of purchase. Purchase costs are approximately 60% of the selling price. Required: Determine for Noskey: 1. Budgeted cash collections in December 2018 from November 2018 credit sales. 2. Budgeted total cash receipts in January 2019. 3. Budgeted total cash payments in December 2018 for inventory purchases. Next Visit question mapQuestion 1 of 3 Total 1 of 3 Prev

1.Like price elasticity of demand, the price elasticity of supply can be measured in terms of changes in total revenue.” True or False.

2. Name two instances where optimizing requires the concept of the “margin”. ?

3. Why is the utility maximizing rule optimal?

Case 7-2 Solutions Network, Inc. (a GVV case)

“We can’t recognize revenue immediately, Paul, since we agreed to buy similar software from DSS,” Sarah Young stated.

“That’s ridiculous,” Paul Henley replied. “Get your head out of the sand, Sarah, before it’s too late.”

Sarah Young is the controller for Solutions Network, Inc., a publicly owned company headquartered in Sunnyvale, California. Solutions Network has an audit committee with three members of the board of directors that are independent of management. Sarah is meeting with Paul Henley, the CFO of the company on January 7, 2016, to discuss the accounting for a software systems transaction with Data Systems Solutions (DSS) prior to the company’s audit for the year ended December 31, 2015. Both Young and Henley are CPAs.

Young has excluded the amount in contention from revenue and net income for 2015, but Henley wants the amount to be included in the 2015 results. Without it, Solutions Network would not meet earnings expectations. Henley tells Young that the order came from the top to record the revenue on December 28, 2015, the day the transaction with DSS was finalized. Young points out that Solutions Network ordered essentially the same software from DSS to be shipped and delivered early in 2016. Therefore, according to Young, Solutions Network should delay revenue recognition on this “swap” transaction until that time. Henley argues against Sarah’s position, stating that title had passed from the company to DSS on December 31, 2015, when the software product was shipped FOB shipping point.

Background

Solutions Network, Inc., became a publicly owned company on March 15, 2011, following a successful initial public offering (IPO). Solutions Network built up a loyal clientele in the three years prior to the IPO by establishing close working relationships with technology leaders, including IBM, Apple, and Dell Computer. The company designs and engineers systems software to function seamlessly with minimal user interface. There are several companies that provide similar products and consulting services, and DSS is one. However, DSS operates in a larger market providing IT services management products that coordinate the entire business infrastructure into a single system.

Solutions Network grew very rapidly during the past five years, although sales slowed down a bit in 2015. The revenue and earnings streams during those years are as follows:

Young prepared the following estimates for 2015:

The Transaction

On December 28, 2015, Solutions Network offered to sell its Internet infrastructure software to DSS for its internal use. In return, DSS agreed to ship similar software 30 days later to Solutions Network for that company’s internal use. The companies had conducted several transactions with each other during the previous five years, and while DSS initially balked at the transaction because it provided no value added to the company, it did not want to upset one of the fastest-growing software companies in the industry. Moreover, Solutions Network might be able to help identify future customers for DSS’s IT service management products.

The $15 million of revenue would increase net income by $1.0 million. For Solutions Network, the revenue from the transaction would be enough to enable the company to meet targeted goals, and the higher level of income would provide extra bonus money at year-end for Young, Henley, and Ed Fralen, the CEO.

Accounting Considerations

In her discussions with Henley, Young points out that the auditors will arrive on January 15, 2016; therefore, the company should be certain of the appropriateness of its accounting before that time. After all, says Sarah, “the auditors rely on us to record transactions properly as part of their audit expectations.” At this point Henley reacts angrily and tells Young she can pack her bags and go if she doesn’t support the company in its revenue recognition of the DSS transaction. Young is taken aback. Henley seems unusually agitated. Perhaps he was under a lot more pressure to “meet the numbers” than she anticipated. To defuse the matter, Sarah makes an excuse to end the meeting prematurely and asks if they could meet on Monday morning, after the weekend. Henley agrees.

Over the weekend, Sarah calls her best friend, Shannon McCollough, for advice. Shannon is a controller at another company and Sarah would often commensurate with Shannon over their mutual experiences. Shannon suggests that Sarah should explain to Paul exactly what her ethical obligations are in the matter. Shannon thinks it might make a difference because Paul is a CPA as well.

After the discussion with Shannon, Sarah considers whether she is being too firm in her position. On the one hand, she knows that regardless of the passage of title to DSS on December 31, 2015, the transaction is linked to Solutions Network’s agreement to take the DSS product 30 days later. While she doesn’t anticipate any problems in that regard, Sarah is uncomfortable with the recording of revenue on December 31 because DSS did not complete its portion of the agreement by that date. She has her doubts whether the auditors would sanction the accounting treatment.

On the other hand, Sarah is also concerned about the fact that another transaction occurred during the previous year that she questioned but, in the end, went along with Paul’s accounting for this transaction. On December 28, 2014, Solutions Network sold a major system for $20 million to Laramie Systems but executed a side agreement with Laramie on that date which gave Laramie the right to return the product for any reason for 30 days. Even though Solutions Network recorded the revenue in 2014 and Sarah felt uneasy about it, she did not object because Laramie did not return the product; her acceptance was motivated by the delay in the external audit until after the 30-day period had expired. Now, however, Sarah is concerned that a pattern may be developing.

Questions

1. Should Sarah follow Shannon’s advice? What if she does and Paul does not back off? What additional levers can she use to influence Paul and make her values understood?
2. What is the most powerful and persuasive response to the reasons and rationalizations Sarah needs to address? To whom should the argument be made? When and in what context?

Case 7-2 Solutions Network, Inc. (a GVV case)

“We can’t recognize revenue immediately, Paul, since we agreed to buy similar software from DSS,” Sarah Young stated.

“That’s ridiculous,” Paul Henley replied. “Get your head out of the sand, Sarah, before it’s too late.”

Sarah Young is the controller for Solutions Network, Inc., a publicly owned company headquartered in Sunnyvale, California. Solutions Network has an audit committee with three members of the board of directors that are independent of management. Sarah is meeting with Paul Henley, the CFO of the company on January 7, 2016, to discuss the accounting for a software systems transaction with Data Systems Solutions (DSS) prior to the company’s audit for the year ended December 31, 2015. Both Young and Henley are CPAs.

Young has excluded the amount in contention from revenue and net income for 2015, but Henley wants the amount to be included in the 2015 results. Without it, Solutions Network would not meet earnings expectations. Henley tells Young that the order came from the top to record the revenue on December 28, 2015, the day the transaction with DSS was finalized. Young points out that Solutions Network ordered essentially the same software from DSS to be shipped and delivered early in 2016. Therefore, according to Young, Solutions Network should delay revenue recognition on this “swap” transaction until that time. Henley argues against Sarah’s position, stating that title had passed from the company to DSS on December 31, 2015, when the software product was shipped FOB shipping point.

Background

Solutions Network, Inc., became a publicly owned company on March 15, 2011, following a successful initial public offering (IPO). Solutions Network built up a loyal clientele in the three years prior to the IPO by establishing close working relationships with technology leaders, including IBM, Apple, and Dell Computer. The company designs and engineers systems software to function seamlessly with minimal user interface. There are several companies that provide similar products and consulting services, and DSS is one. However, DSS operates in a larger market providing IT services management products that coordinate the entire business infrastructure into a single system.

Solutions Network grew very rapidly during the past five years, although sales slowed down a bit in 2015. The revenue and earnings streams during those years are as follows:

Young prepared the following estimates for 2015:

The Transaction

On December 28, 2015, Solutions Network offered to sell its Internet infrastructure software to DSS for its internal use. In return, DSS agreed to ship similar software 30 days later to Solutions Network for that company’s internal use. The companies had conducted several transactions with each other during the previous five years, and while DSS initially balked at the transaction because it provided no value added to the company, it did not want to upset one of the fastest-growing software companies in the industry. Moreover, Solutions Network might be able to help identify future customers for DSS’s IT service management products.

The $15 million of revenue would increase net income by $1.0 million. For Solutions Network, the revenue from the transaction would be enough to enable the company to meet targeted goals, and the higher level of income would provide extra bonus money at year-end for Young, Henley, and Ed Fralen, the CEO.

Accounting Considerations

In her discussions with Henley, Young points out that the auditors will arrive on January 15, 2016; therefore, the company should be certain of the appropriateness of its accounting before that time. After all, says Sarah, “the auditors rely on us to record transactions properly as part of their audit expectations.” At this point Henley reacts angrily and tells Young she can pack her bags and go if she doesn’t support the company in its revenue recognition of the DSS transaction. Young is taken aback. Henley seems unusually agitated. Perhaps he was under a lot more pressure to “meet the numbers” than she anticipated. To defuse the matter, Sarah makes an excuse to end the meeting prematurely and asks if they could meet on Monday morning, after the weekend. Henley agrees.

Over the weekend, Sarah calls her best friend, Shannon McCollough, for advice. Shannon is a controller at another company and Sarah would often commensurate with Shannon over their mutual experiences. Shannon suggests that Sarah should explain to Paul exactly what her ethical obligations are in the matter. Shannon thinks it might make a difference because Paul is a CPA as well.

After the discussion with Shannon, Sarah considers whether she is being too firm in her position. On the one hand, she knows that regardless of the passage of title to DSS on December 31, 2015, the transaction is linked to Solutions Network’s agreement to take the DSS product 30 days later. While she doesn’t anticipate any problems in that regard, Sarah is uncomfortable with the recording of revenue on December 31 because DSS did not complete its portion of the agreement by that date. She has her doubts whether the auditors would sanction the accounting treatment.

On the other hand, Sarah is also concerned about the fact that another transaction occurred during the previous year that she questioned but, in the end, went along with Paul’s accounting for this transaction. On December 28, 2014, Solutions Network sold a major system for $20 million to Laramie Systems but executed a side agreement with Laramie on that date which gave Laramie the right to return the product for any reason for 30 days. Even though Solutions Network recorded the revenue in 2014 and Sarah felt uneasy about it, she did not object because Laramie did not return the product; her acceptance was motivated by the delay in the external audit until after the 30-day period had expired. Now, however, Sarah is concerned that a pattern may be developing.

Questions

1. Should Sarah follow Shannon’s advice? What if she does and Paul does not back off? What additional levers can she use to influence Paul and make her values understood?
2. What is the most powerful and persuasive response to the reasons and rationalizations Sarah needs to address? To whom should the argument be made? When and in what context?

Perform a linear time series regression (“Trend Analysis” in Minitab or “Trendline” in Excel) of the historical data. For the parts below, generate a regression output report produced in either Excel or Minitab and submit it with your completed test.

a.   Attach a copy of your “Trend Analysis” or “Trendline” graph in a space created BELOW.

b.   State (here) the equation of the fitted regression line.

c.   On the basis of this regression analysis, calculate and state numerical values of the sales revenue forecasts for all four quarters of 2018.

d.   Calculate and state (here) the RMSE of this simple linear regression. [Hint: Different from forecasting, for regression RMSE = √SSE/√(n-2).]

Monthly revenue for the past 20 months of all the products sold in the Health and Beauty Department of Green Corporation is contained in the Excel data file. Use that data to answer the following.

1. Obtain a Moving Average forecast of the data using 3 periods to get the moving average – i.e., MA3 forecast. Plot the results on one chart with the plots showing both the actual line and the MA3 line. Show the screenshot of the plot (copy as picture and paste) below. What is the MAD of this forecast? What is the MAPE?

2. Obtain the Exponential Smoothing (ES) Forecast using a = 0.25. Plot the results on one chart with the plots showing both the actual line and the ES forecast line. Show the screenshot of the plot (copy as picture and paste) below. What is the MAD of this forecast? What is the MAPE?

A garage is installing a new​ "bubble-wash" car wash. It will promote the car wash as a fun activity for the​ family, and it is expected that the novelty of this approach will boost sales in the medium term. If the cost of capital is 88​%,by using the data in the table​ above, calculate the net present value​ (NPV) of this project.