Susan Corporation started the year expecting to produce and sell 117,000 units of its super-insulating coffee mugs, but it ended the year having produced and sold even more than that-129,000 units. Needless to say, owners Eli and his sister Anna were thrilled to have exceeded sales goals for the year. By the end of the third quarter, results looked promising. They were even more excited to see the final year-end financial statements and share the great news with their crew. The actual results, along with the original master budget for the year, are as follows. Sales Variable costs: DM DL Variable-MOH Variable SG&A Contribution margin Fixed costs: Fixed-MOH Fixed SG&A Operating income Actual Income $2,560,650 389,064 621,264 268,320 122,550 1,159,452 442,728 436,500 $280,224 Flexible Budget Master Budget $2,357,550 351,000 561,600 210,600 111,150 1,123,200 421,200 409,000 $293,000 In addition to seeing total actual results, the owners would like a more thorough analysis of many of these accounts.

Susan Corporation started the year expecting to produce and sell 117,000 units of its super-insulating coffee mugs, but it ended the year having produced and sold even more than that-129,000 units. Needless to say, owners Eli and his sister Anna were thrilled to have exceeded sales goals for the year. By the end of the third quarter, results looked promising. They were even more excited to see the final year-end financial statements and share the great news with their crew. The actual results, along with the original master budget for the year, are as follows. Sales Variable costs: DM DL Variable-MOH Variable SG&A Contribution margin Fixed costs: Fixed-MOH Fixed SG&A Operating income Actual Income $2,560,650 389,064 621,264 268,320 122,550 1,159,452 442,728 436,500 $280,224 Flexible Budget Master Budget $2,357,550 351,000 561,600 210,600 111,150 1,123,200 421,200 409,000 $293,000 In addition to seeing total actual results, the owners would like a more thorough analysis of many of these accounts.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter7: Inventory Cost Flow Assumptions (fifolifo)

Section: Chapter Questions

Problem 1R: Del Rio began Rio Enterprises on January 1 with 200 units of inventory. During the year, 500...

See similar textbooks

Similar questions

V Energy Tech Ltd. has just had a very profitable year as rising energy costs have driven a rapid increase in sales of its solar power cells. The firm also developed a new process which has lowered its manufacturing costs significantly. V Energy Tech believes that this new process will give it a major advantage over its competitors, which it estimates will last for three years. It expects to enjoy high profits during this period, estimating profit growth over the next three years to be 18%, 16% and 13% respectively, before returning to constant industry growth pattern of 6% per year in year 4. V Energy Tech Ltd. has just paid a dividend of $2.50 per share and expects that the dividend will grow at the same rate as its profits. The firm’s cost of capital is 9%. a. What is the firm’s share price today (P0)? b. What is the expected share price next year (P1)? c. Calculate the dividend yield for year 2. d. Calculate the current capital gains yield (year 1).
V Energy Tech Ltd. has just had a very profitable year as rising energy costs have driven a rapid increase in sales of its solar power cells. The firm also developed a new process which has lowered its manufacturing costs significantly. V Energy Tech believes that this new process will give it a major advantage over its competitors, which it estimates will last for three years. It expects to enjoy high profits during this period, estimating profit growth over the next three years to be 18%, 16% and 13% respectively, before returning to constant industry growth pattern of 6% per year in year 4. V Energy Tech Ltd. has just paid a dividend of $2.50 per share and expects that the dividend will grow at the same rate as its profits. The firm’s cost of capital is 9%. What is the firm’s share price today (P0)? What is the expected share price next year (P1)? Calculate the dividend yield for year 2. Calculate the current capital gains yield (year 1).
Gorilla, Inc., has recently launched a ramen/sushi fusion dish that has received an overwhelmingly positive reaction from the market. In response to this success, the company is reinvesting all of its earnings to fuel further expansion. This past year, the earnings per share stood at $10, and these are anticipated to increase by 20% annually over the next five years. However, by the end of the fifth year, it's expected that competitors will introduce similar products. Consequently, analysts forecast that Gorilla will then reduce its reinvestment rate and start distributing 60% of its earnings as dividends. Additionally, from that point onwards, the company's growth rate is projected to decelerate to a stable 3% per annum. If Gorilla's equity cost of capital is 8%, what is the value of a share today? Complete the table below. You can use an Excel spreadsheet and then copy and paste the sheet. Additionally, please provide detailed explanations beneath the table on how to determine the…
Ameen trading company is a popular distributor in the Nizwa region having years of experience in the field of logisties and marketing. Over these years, the company has gained a very good public opinion and quiet a big number of loyal customers. During the last year, the company has faced some financial struggles due to the pandemic - crisis. The company has decided to plan well for the current year based on the past performance so that the company will be able to regain its status. The management of the company has given with you the Income statement for the last year and asked you to calculate the gross profit and net profit margin. Partkular OMR Particular OMR Opening Stock Purchases Carriage and Freight Wages Gross Profit bd To 76,250 By Sales 315 250 "Closing stock 2,000 5,000 2,00,000 5,98500 1,01,000 By Gross Profit b/d 12000 Non-operating incomes 2,000 7 p00 *Dividend on shares 84 000 Profit on sale of shares 2,06,000 5,00,000 98,500 5,98,500 2,00,000 To Administration expenses…
Ameen trading company is a popular distributor in the Nizwa region having years of experience in the field of logistics and marketing. Over these years, the company has gained a very good public opinion and quiet a big number of loyal customers. During the last year, the company has faced some financial struggles due to the pandemic – crisis. The company has decided to plan well for the current year based on the past performance so that the company will be able to regain its status. The management of the company has given with you the Income statement for the last year and asked you to calculate the gross profit and net profit margin. Particular OMR Particular OMR Opening Stock Purchases Carriage and Freight Wages Gross Profit b/d To 76,250 By Sales 3,15,250 "Closing stock 2,000 5,000 2,00,000 5,98,500 1,01,000 By Gross Profit b/d 12,000 "Non-operating incomes: 2,000 " Interest on Securities 7,000 " Dividend on shares 84,000 " Profit on sale of shares 2,06,000 5,00,000 98,500 5,98,500…
Marcia curtis is the vice president of development for Tamales to go a rapidly expanding chain of resturant featuring take tamales and other mexican food specialties. Currently, the chain has 150 units and average unit volume is $800,000 per year. Annual per-unit revenue growth for opened units is 5 percent per year. Tonya Gonzalez, the chain's president, has promised company stockholders the chain will experience 12 percent overall reveue growth in the next year. Assuming that per-unit growth on existing units continues to average 5 percent, calculate how many total operating units Marcia will need to have open next year to meet Tonya's goal of a 12 percent overall increase in the chain's revenue. Total Revenue-$120,000,000 Per Unit Revenue-$800,000 Total Number of Units- 150
S. Liang Inc. is a new concept on-line store that has proven to be very popular in the past year. Mrs. Liang and her team worked very hard in the past year in developing the brand and she indicated that she spent approximately $5,000,000 in a large marketing and customer service initiative. In an article published in December 2016, the business journal has indicated that their brand name is estimated to be worth $12,000,000 based on an analysis they performed. On their balance sheet for December 31, 2016, Liang Inc should record: a) An intangible asset worth $5,000,000 b) An intangible asset worth $7,000,000 c) An intangible asset worth $12,000,000 d) No intangible asset should be recorded at December 31, 2016.
Malone Industries has been in business for five years and has been very successful. In the past year, it expanded operations by buying Hot Metal Manufacturing for a price greater than the value of the net assets purchased. In the past year, the customer base has expanded much more than expected, and the companys owners want to increase the goodwill account. Your CPA firm has been hired to help Malone prepare year-end financial statements, and your boss has asked you to talk to Malones managers about goodwill and whether an adjustment can be made to the goodwill account. How do you respond to the owners and managers?
Adli Yunus is the vice president of development for Eddlee Fried Chicken a rapidly expanding chain of restaurants featuring takeout fried chicken and other Malay food specialties. Currently, the chain has 150 units and the average unit volume is$800,000 per year. Annual per-unit revenue growth for opened units is 5 percent per year. Baba Tomi, the chain's president, has promised company stakeholders the chain will experience 12 percent overall revenue growth in the next year. Assuming that per-unit growth on existing units continues to average 5 percent, calculate the total revenue next year.
The manager at the Overton Hotel in Lubbock believes that the success of the Texas Tech Red Raider Basketball team has an impact on the occupancy rate at the hotel during the first quarter of every year. Below are the number of victories for the Red Raiders in during the last three seasons and the hotel occupancy rate. This year, (year 4) the Red Raiders Basketball Team is expected to win 28 games and the manager at the Overton has asked you to determine their first quarter occupancy rate for the upcoming year (year 4) using associative forecasting. Year Wins First Quarter Occupancy Rate 1 25 2 3 27 31 88.32% 91.25% Ⓒ90.29% Ⓒ86.36% 92.21% 80% 90% 93%
The Best Appliances had the following revenue over the past five Wars, To predict revenues for 2018, The Best Appliances uses the average for the Past five years. The company’s breakeven revenue is $800,000 per year. What is The Best Appliance’s predicted margin of safety in dollars for 2018? $800,000 $0 $200,000 $100,000
Alif trading company is a popular distributor in Salala, having operations in the entire Oman. Over these years, the company has gained a very good public opinion and quiet a big number of loyal customers. During the last year, the company has faced some financial struggles due to the pandemic - crisis. The company has decided to plan well for the current year based on the past performance so that the company will be able to regain its status. The management of the company has given with you the Income statement for the last year and asked you to calculate the gross profit and net profit margin. Partkula OMR OM Particular Sales AI520 Clesitoc 2000 5000 100000 To Ovening Stock Torchases Karnage d Wags JGrom Proft bd 600.000 To LOL00 Gross Profie bd 120o0 " 2000 teret on Securities 70o0Dvdend on shares I4 Do Prot ensae of sares 3,0.0 Tramstrationegeres 300000 Nonoperating incomes Selling and Dist egese Nonoperatingegeses FFirancial Espenes Net Proft c/ 1500 1750 750 Choose the Gross…