It all begins with a phone call from your mother. She tells you, You uncle Murray...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
It all begins with a phone call from your mother. She tells you, "You uncle Murray needs your help." You reply, "Of course he does mom, your brother isn't the freshest egg in the 'fridge." "Don't say that" mom replies. "He knows that you're in college studying business and he needs someone to create a few financial statements for his local banker. I told him that you could help." After the shock wears off of having to actually use something that you had quickly forgotten after last year's final exam you ask, "What financial statements does his banker need?" "So, you'll help? Oh, that's wonderful dear. He said he needed an income statement." "Okay mom, I think I can maybe do that." Mom then tells you, "Murray also needs something called a statement of the cost of goods sold. Do you know what that is? He said something about cost of goods manufactured also. Can you do that too?" That feeling of standing on the razor's edge of confidence and sheer panic overcomes you. Not knowing what else to do you ask your mother if Uncle Murray provided any financial data that you could use to create these financial schedules. "Certainly", says your mom and begins to rattle off the following information that she wrote down on the back of an envelope; "He said that his company only had to pay $500 in interest expense, and that in its raw materials accounting the beginning and ending balances were $53,000 and 22,000 respectively." Murray also told your mother that they purchased $76,000 of additional raw materials during the year, and that his company's work in process had a beginning balance of $18,000 and an ending balance of $9,000. Murray's company incurred $147,000 of administrative expenses and $57,205 in selling costs during the year. The company had direct labor costs of $81,000, and it incurred manufacturing overhead costs of $44,000. There were $2,900 worth of indirect materials used for production this year, and $41,000 worth of manufacturing overhead was applied to work in process. Your mother also tells you that Murray's company began the year with $46,000 worth of goods in its finished goods inventory and that they counted $38,000 of goods at the end of the year. She then tells you, "Murray is doing fantastic dear. He's going to be so rich. He told me that his company has sales of $453,367 last year, but that his tax rate is 21%. Isn't he doing great?" With a bit of hesitancy in your voice you reply, "Maybe so mom. I'll let you know." Requirements: Using the above information, you are to create in Excel the following: A) Schedule of Cost of Goods Manufactured B) Schedule of Cost of Goods Sold C) Traditional Income Statement •The input data must be in its own separate section of your spreadsheet. • Your spreadsheet will have the Schedules of the Cost of Goods Manufacture, Cost of Goods Sold, and the Income Statement. . Your workbook must be dynamic. If even one item from the input data section is changed then the Net Income will change. Make certain the formula in your cell for the adjustment of over/under applied manufacturing overhead is dynamic. The label for this cell should be "Adjustment for (Over) or Under Applied Overhead". • You will also disclose who you worked with, or that you worked alone, on this first sheet. Your name is to be included in the title of your file: "Excel #2, YOUR NAME" Must be submitted through Blackboard & is worth ten possible points. It all begins with a phone call from your mother. She tells you, "You uncle Murray needs your help." You reply, "Of course he does mom, your brother isn't the freshest egg in the 'fridge." "Don't say that" mom replies. "He knows that you're in college studying business and he needs someone to create a few financial statements for his local banker. I told him that you could help." After the shock wears off of having to actually use something that you had quickly forgotten after last year's final exam you ask, "What financial statements does his banker need?" "So, you'll help? Oh, that's wonderful dear. He said he needed an income statement." "Okay mom, I think I can maybe do that." Mom then tells you, "Murray also needs something called a statement of the cost of goods sold. Do you know what that is? He said something about cost of goods manufactured also. Can you do that too?" That feeling of standing on the razor's edge of confidence and sheer panic overcomes you. Not knowing what else to do you ask your mother if Uncle Murray provided any financial data that you could use to create these financial schedules. "Certainly", says your mom and begins to rattle off the following information that she wrote down on the back of an envelope; "He said that his company only had to pay $500 in interest expense, and that in its raw materials accounting the beginning and ending balances were $53,000 and 22,000 respectively." Murray also told your mother that they purchased $76,000 of additional raw materials during the year, and that his company's work in process had a beginning balance of $18,000 and an ending balance of $9,000. Murray's company incurred $147,000 of administrative expenses and $57,205 in selling costs during the year. The company had direct labor costs of $81,000, and it incurred manufacturing overhead costs of $44,000. There were $2,900 worth of indirect materials used for production this year, and $41,000 worth of manufacturing overhead was applied to work in process. Your mother also tells you that Murray's company began the year with $46,000 worth of goods in its finished goods inventory and that they counted $38,000 of goods at the end of the year. She then tells you, "Murray is doing fantastic dear. He's going to be so rich. He told me that his company has sales of $453,367 last year, but that his tax rate is 21%. Isn't he doing great?" With a bit of hesitancy in your voice you reply, "Maybe so mom. I'll let you know." Requirements: Using the above information, you are to create in Excel the following: A) Schedule of Cost of Goods Manufactured B) Schedule of Cost of Goods Sold C) Traditional Income Statement •The input data must be in its own separate section of your spreadsheet. • Your spreadsheet will have the Schedules of the Cost of Goods Manufacture, Cost of Goods Sold, and the Income Statement. . Your workbook must be dynamic. If even one item from the input data section is changed then the Net Income will change. Make certain the formula in your cell for the adjustment of over/under applied manufacturing overhead is dynamic. The label for this cell should be "Adjustment for (Over) or Under Applied Overhead". • You will also disclose who you worked with, or that you worked alone, on this first sheet. Your name is to be included in the title of your file: "Excel #2, YOUR NAME" Must be submitted through Blackboard & is worth ten possible points.
Expert Answer:
Related Book For
Applying Communication Theory For Professional Life A Practical Introduction
ISBN: 9781506315478
4th Edition
Authors: Marianne Dainton, Elaine D. Zelley
Posted Date:
Students also viewed these accounting questions
-
Lisa, Steve, and Chen were feeling triumphant. Just 3 months ago, their company, Ryan Project Systems, had merged with Gierig Strategien AG, a consulting firm headquartered in Germany. At the time,...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Outline the accounting procedures involved in applying the operating method by a lessee.
-
In a recent year, Avaya, Inc., an East Coast telecommunications company, issued 34,300,000 shares of common stock for a total of $212,000,000.15. As a growing company, Avaya could have raised this...
-
The payroll clerk at Photo Workshop has asked you to create an application that displays an employees net pay. The application should allow the payroll clerk to enter the employees name, hours...
-
The following data are for Marvin Department Store. The account balances (in thousands) are for 2017. 1. Compute (a) the cost of goods purchased and (b) the cost of goods sold. 2. Prepare the income...
-
On September 1, Nixa Office Supply had an inventory of 30 calculators at a cost of $18 each. The company uses a perpetual inventory system. During September, the following transactions occurred....
-
3. A function f has the values shown below: x 1 1.25 1.5 1.75 f(x) 10 8 7 6 a. Use Midpoint rule to approximate f(x)dx b. Use Simpson's rule to approximate f(x)dx 25
-
Bilkins Financial Advisors provides accounting and finance assistance to customers in the retail business. Bilkins has four professionals on staff, plus an office with six clerical staff. Total...
-
Consider the three types of economic shocks: financial shocks, spending shocks, and supply shocks. Discuss how each one affects the real interest rate, output gap, and the inflation rate.
-
How can you cultivate teams that resist enculturation and stand out to create in a world that encourages conformity?
-
Do you have a checking or savings account? Why or why not? Would you still have an account if you earned no interest on your deposits? What if you had to pay fees?
-
The International Monetary Fund (IMF) publishes World Economic Outlook Updates biannually. According to the July 2018 Update, the expected annual growth rate of advanced countries was 2.2% for 2019....
-
Why do people value liquidity? What are the different ways that banks, the bond market, and the stock market create liquidity?
-
A juggler holds a very long barbell with masses, positions, and angle as shown. She supports it at the pivot point (which is not the center of mass). Gravity acts on each ball downwards. Her...
-
In the circuit shown in Figure 4, a battery supplies a constant voltage of 40 V, the inductance is 2 H, the resistance is 10, and l(0) = 0. (a) Find l(t). (b) Find the current after 0.1s.
-
Historic Philadelphia is a booming travel destination. Among the many sites tourists visit while in one of the nations oldest cities is the Granovetter Church, a partially restored building nearly...
-
In 1969, a radical new childrens program appeared on television, one specifically designed to blend education with entertainment (characterproducts.com, 2004). Sesame Street, which has been on the...
-
Evelyn and Doug were active in their retirement. They both spent a lot of time working for their community theater group, organizing fund-raisers, building sets, and selling tickets. As full as their...
-
Mexico has labor laws that specify a daily (rather than hourly) minimum wage. In 2018, the daily minimum wage in Mexico was about 103 pesos per day, and the exchange rate between Mexican pesos and...
-
In 2017, an estimated 7.7 million Mexican-born immigrants were employed in the United States. a. If 60 percent of the Mexican-born immigrants remitted money to family members in Mexico in 2017, and...
-
A mathematical approximation called the rule of 70 tells us how long it will take for something to double in size if it grows at a constant rate. The doubling time is approximately equal to the...
Study smarter with the SolutionInn App