suggest steps the company might take to reduce its losses and establish profitability,

the cenario:

Reitmans Ltd. (RET.TO) says it had a net loss of $3.2 million in the last quarter in an improvement from the $6.6 million net loss in the same quarter a year earlier (The Canadian Press, 2018).

Reitmans management says sales were $207.6 million in the quarter, compared with $207.1 million a year earlier despite a net reduction of 32 stores, while promotional costs were up on increased activity. The company said in March it would close its 17 Hyba athletic clothing stores by next February and move the brand into the company's existing Reitmans stores (The Canadian Press, 2018).

Reitmans also states Online sales jumped 21.9 per cent in the quarter while store sales dropped 3.9 per cent.

Reference

The Canadian Press. (2018, June 05). Reitmans reports $3.2M net loss; sales steady despite store closures - Article. Retrieved from https://www.bnnbloomberg.ca/reitmans-reports-3-2m-net-loss-sales-steady-despite-store-closures-1.1088263

Using Intermediate Accounting 16 edition by Kieso, Weygandt, Warfield answer the following:

Fife Company prepares quarterly reports following generally accepted accounting principles. For each of the items below, state whether the method is in conformity with generally accepted accounting principles with an explanation of your answer and appropriate justification:

a. Fife takes a physical inventory at year-end for annual financial statements. Inventory and cost of sales reported in quarterly reports are based on estimated gross profit rates. Fife does have reliable perpetual inventory records.

b. The company records income tax expense for each quarter based on the expected tax rate for the year rather the tax rate based on the quarter’s income.

c. The company had a loss on a discontinued operation in the third quarter. The company plans to recognize one-half of the loss in each of the third and fourth quarters.

d. The company reports inventory at lower of cost or market. At the end of the second quarter, the market value was below cost. Fife did not report a loss for the quarter since they expected the year-end market value to exceed year-end cost.

National Tire LTD. reported the following in its financial statements for the quarter ended March 31, 2014.

During the quarter ended March 31, 2014, National reported Net Income of $8,250 and declared and paid cash dividends totalling $8,250.

Required:
1. Calculate earnings per share (EPS) and return on equity (ROE) for the quarter ended March 31, 2014. (Round your Earnings per share answer to 2 decimal place.)

2. Assume that National repurchases 10,000 of its common shares at a price of $2.25 per share on April 1, 2014. Also assume that during the quarter ended June 30, 2014, National reported Net Income of $8,250 and declared and paid cash dividends totalling $8,250. Calculate earnings per share (EPS) and return on equity (ROE) for the quarter ended June 30, 2014

. (Round "Earnings per share" to 3 decimal places and "Return on equity" to 2 decimal place.)

3. Based on your calculations in requirements 1 and 2, what can you conclude about the impact of a share repurchase on EPS and ROE? \

Python 3

A simple way to encrypt a file is to change all characters following a certain encoding rule. In this question, you need to move all letters to next letter. e.g. 'a'->'b', 'b'->'c', ..., 'z'->'a', 'A'->'B', 'B'->'C', ..., 'Z'->'A'. For all digits, you need to also move them to the next number. e.g. '0'->'1', '1'->'2', ..., '9'->'0'. All the other symbols should not be changed.

1. Write a function encrypt with the following requirements:

• the function takes a string argument, which is a file name.
• read the csv file.
• replace all characters uisng the rule above.
• write the content to a new file named "encrypted.csv".

2. Call the function with the file name "business-price-indexes-june-2020-quarter-csv-corrected.csv"

--2020-10-16 19:32:31-- https://www.stats.govt.nz/assets/Uploads/Business-price-indexes/Business-price-indexes-June-2020-quarter/Download-data/business-price-indexes-june-2020-quarter-csv-corrected.csv Resolving www.stats.govt.nz (www.stats.govt.nz)... 45.60.11.104 Connecting to www.stats.govt.nz (www.stats.govt.nz)|45.60.11.104|:443... connected. HTTP request sent, awaiting response... 200 OK Length: 11924606 (11M) [text/csv] Saving to: ‘business-price-indexes-june-2020-quarter-csv-corrected.csv’ business-price-inde 100%[===================>] 11.37M 4.56MB/s in 2.5s 2020-10-16 19:32:34 (4.56 MB/s) - ‘business-price-indexes-june-2020-quarter-csv-corrected.csv’ saved [11924606/11924606]

Consider the following time series data.

(a) Create the correct time series plot. Which type of pattern exists in the data?

(b) Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. If required, round your answers to three decimal places. For subtractive or negative numbers, use a minus sign even if there is a + sign before the blank. (Example: -300) If the constant is 1, it must be entered in the box. Do not round intermediate calculations.

(c) Compute the quarterly forecasts for next year based on the model you developed in part (b). If required, round your answers to three decimal places. Do not round intermediate calculations.

(d) Use a multiple regression model to develop an equation to account for trend and seasonal effects in the data. Use the dummy variables you developed in part (b) to capture seasonal effects and create a variable t such that t = for Quarter 1 in Year 1, t = 2 for Quarter 2 in Year 1,... t = 12 for Quarter 4 in Year 3. If required, round your answers to three decimal places. For subtractive or negative numbers, use a minus sign even if there is a + sign before the blank. (Example: -300)

(e) Compute the quarterly forecasts for next year based on the model you developed in part (d). Do not round your interim computations and round your final answer to three decimal places.

(f) Find MSE of the model developed in part (b) and the model developed in part (d). Which one is the more effective model? If required, round your intermediate calculations and final answer to three decimal places.

---

If possible, for the tasks that require to use Excel, can you please help show me how to do those steps in Excel, especially how to create the time series plot in part a?

Thank you very much.

7.

1. Construct a time series plot. Comment on what type of pattern exists in the data.
2. Use a regression model with dummy variables as follow to explain sales: Qtr1 = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. Write out the model that you’ve estimated in equation form using the values of your estimates. Explain, in a sentence or two, what this model tells us.
3. Use a new, simple linear regression model with “t” as the only predictor where t = 1 for the 1^st quarter of year 1, t = 2 for the 2^nd quarter of year 1,…, t = 12 for the 4^th quarter of year 3. Write out the model that you’ve estimated in equation form using your values of the estimates. Explain, in a sentence or two, what this model tells us.
4. Use a new regression model with BOTH the dummy variable approach you created in part “b” and the time predictor, “t” that you created in part “c.” Write out the model that you’ve estimated in equation form. Explain, in a sentence or two, what this model tells us.
5. Compute (or take from Excel) the mean squared error (MSE) from each of your models from “b”, “c”, and “d.” (Hint: MSE is the same as MS Residual on the Excel output). Comment, in a sentence or two, on which of the models appears the best and why. Does this match up with the adjusted R^2 values of the models?
6. Using the model that you identified as the “best” in “e”, compute the quarterly forecasts for the year AFTER next (skip year 4, and tell me the forecasts for Q1, Q2, Q3, and Q4 of year 5). If you were going to tell the textbook store manager your forecasts, would you tell him/her exactly these numbers? Might there be a reason to explain your numbers slightly? What would you tell the manager?

Suppose that Dom began a landscaping business in 2020. In that year, he adopted the last-in first-out (LIFO) inventory-flow method for his business inventory of shrubbery by using it for the year on his tax return.

In 2019, he purchased the following four batches of shrubs (total cost per batch below).

   Shrubs         Purchase Date        Direct Cost         Other Inventoriable Costs      Total Cost
      200               July 21                 $ 2,000              $ 200                                $ 2,200

      150              August 15              $ 2,000              $ 100                                $ 2,100
      100             October 30              $ 2,200              $ 400                                $ 2,600
      140            November 10            $ 2,700              $ 100                                $ 2,800

In 2020, Dom sold 200 shrubs. In 2021, Dom purchased three more batches of shrubs at the following total cost per batch below. Just before year end in 2021, he also sold 50 shrubs:

                       Shrubs             Purchase Date               Total Cost
                        100                 Early spring                   $ 2,400
                        125                    Summer                      $ 2,500
                        100                        Fall                         $ 2,600

a.     (10 points) What cost of goods sold and ending inventory would Dom record if he elects to use the LIFO method in 2020?

b.    (10 points) What will be his cost of goods sold and ending inventory in 2021 under the LIFO method?

c.     (10 points) How would you answer (a) change if Dom had initially selected the first-in, first-out (FIFO) method instead of LIFO?

d.    (10 points) How would you answer (b) change if Dom had initially selected the first-in, first-out (FIFO) method instead of LIFO?

Business Budget Project Bobcat Printing makes custom t - -- shirts and other promotional products for student organizations and businesses. It is beginning its first year of operations and needs to plan for its first quarter of operations. They would like to maximize their profits, and understand that accurate budgeting can help achieve that goal. The budgets will be prepared based on the following information:

a. Sales are budgeted at $ 20,000 for Month 1, $ 2 5,0 00 for Month 2, and $27 ,000 for Month 3. All sales will be d one on account. Company does not expect to have any cash sales.

b. Sales are collected 6 0% in the month of the sale, and 40% in the month following the sale.

c. Cost of Goods Sold is budgeted at 45 % of Sales.

d. Monthly selling, general, and administrative expenses are as follows: donations are 10% of sales; advertising is 3% of sales; miscellaneous is 1% of sales; and rent is $5,000 per month. All SG&A expenses are paid in the month they are incurred.

e. Since all of the orders are custom made, n o inventory is kept on hand at the end of the month.

f. Inventory purchases are paid in full in the month following the purchase.

g. Bobcat Printing is planning to purchase a building in Month 3 for $6 ,000 in cash.

h. They would like to maintain a minimum cash balance of $2,500 at the end of each month. The company has an agreement with a local bank that allows them to borrow, with a total line of credit of $20,000. The interest rate on these loans is 1% per month (12% annual) . They would as far as able, repay the loan on the last day of the month when it has enough cash to pay the full balance and maintain an adequate ending cash balance.

i. The owner makes a draw of $3 ,000 every month. (Note: sole proprietors and partnerships take owner’s draws, while stockholders receive dividends).

When making calculations always round up (for example: 33 × 7% = 2.31, round up to 3.00).

Check Figures: Gross Margin $39,6 00 Total assets $19,300 Ending Retained Earnings $5,507