Budgeted income statement and supporting budgets for three months Newport Inc. gathered the following data for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Budgeted income statement and supporting budgets for three months Newport Inc. gathered the following data for use in developing the budgets for the first quarter (June, July, August) of its fiscal year: a. Estimated sales at $36 per unit: June 300,000 units July 400,000 units August 500,000 units September 500,000 units b. Estimated finished goods inventories: May 31 16,000 units June 30 5% of next month's sales July 31 5% of next month's sales August 31 5% of next month's sales c. Work in process inventories are estimated to be insignificant (zero). d. Estimated direct materials inventories: May 31 35,000 pounds June 30 40,000 pounds July 31 45,000 pounds August 31 50,000 pounds e. Manufacturing costs: Per Unit Direct materials (1.5 Ibs. per unit x $4 per Ib.) Direct labor (0.4 hr. per unit x $25 per hr.) $ 6.00 10.00 Variable factory overhead ($4 per direct labor hour) 1.60 Fixed factory overhead ($1,200,000 per month allocated using 500,000 units) 2.40 Total per-unit manufacturing costs $20.00 f. Selling expenses: Variable selling expenses $3 per unit Fixed selling expenses $800,000 Administrative expenses (all fixed costs) $550,000 6. Prepare a cost of goods sold budget for August. For those boxes in which you must enter subtracted or negative numbers use a minus sign. Newport Inc. Cost of Goods Sold Budget For the First Quarter Ending August 31 June 320,000 July First Quarter 400,000 August 500,000 320,000 Beginning finished goods inventory Cost of goods manufactured: Direct materials v Direct labor 1,824,000 2,430,000 3,000,000 7,254,000 v 3,040,000 4,050,000 5,000,000 12,090,000 Factory overhead v 1,686,400 1,848,000 2,000,000 5,534,400 Total cost of goods manufactured 6,550,400 $ 8,328,000 10,000,000 24,878,400 Cost of finished goods available for sale v Ending finished goods inventory v Cost of goods sold v 6,870,400 $ 8,728,000 $ 10,500,000 $ 25,198,400 400,000 500,000 500,000 500,000 6,470,400 $ 8,228,000 10,000,000 24,698,400 8. Prepare a budgeted income statement with budgeted operating income for August. For those boxes in which you must enter subtracted or negative numbers use a minus sign. Newport Inc. Budgeted Income Statement For the First Quarter Ending August 31 July August 18,000,000 First Quarter June Sales v $ 10,800,000 $ 14,400,000 43,200,000 Cost of goods sold v 8,228,000 10,000,000 24,698,400 6,470,400 х х х х Gross profit 4,329,600 6,172,000 8,000,000 8,000,000 18,501,600 Selling and administrative expenses: Selling expenses v Administrative expenses V $ 1,700,000 $ 2,000,000 2,300,000 6,000,000 х 550,000 550,000 550,000 1,650,000 х х х х Total selling and administrative expenses 2,250,000 2,550,000 2,850,000 7,650,000 х х х х Operating income v 2,079,600 3,622,000 5,150,000 10,851,600 Budgeted income statement and supporting budgets for three months Newport Inc. gathered the following data for use in developing the budgets for the first quarter (June, July, August) of its fiscal year: a. Estimated sales at $36 per unit: June 300,000 units July 400,000 units August 500,000 units September 500,000 units b. Estimated finished goods inventories: May 31 16,000 units June 30 5% of next month's sales July 31 5% of next month's sales August 31 5% of next month's sales c. Work in process inventories are estimated to be insignificant (zero). d. Estimated direct materials inventories: May 31 35,000 pounds June 30 40,000 pounds July 31 45,000 pounds August 31 50,000 pounds e. Manufacturing costs: Per Unit Direct materials (1.5 Ibs. per unit x $4 per Ib.) Direct labor (0.4 hr. per unit x $25 per hr.) $ 6.00 10.00 Variable factory overhead ($4 per direct labor hour) 1.60 Fixed factory overhead ($1,200,000 per month allocated using 500,000 units) 2.40 Total per-unit manufacturing costs $20.00 f. Selling expenses: Variable selling expenses $3 per unit Fixed selling expenses $800,000 Administrative expenses (all fixed costs) $550,000 6. Prepare a cost of goods sold budget for August. For those boxes in which you must enter subtracted or negative numbers use a minus sign. Newport Inc. Cost of Goods Sold Budget For the First Quarter Ending August 31 June 320,000 July First Quarter 400,000 August 500,000 320,000 Beginning finished goods inventory Cost of goods manufactured: Direct materials v Direct labor 1,824,000 2,430,000 3,000,000 7,254,000 v 3,040,000 4,050,000 5,000,000 12,090,000 Factory overhead v 1,686,400 1,848,000 2,000,000 5,534,400 Total cost of goods manufactured 6,550,400 $ 8,328,000 10,000,000 24,878,400 Cost of finished goods available for sale v Ending finished goods inventory v Cost of goods sold v 6,870,400 $ 8,728,000 $ 10,500,000 $ 25,198,400 400,000 500,000 500,000 500,000 6,470,400 $ 8,228,000 10,000,000 24,698,400 8. Prepare a budgeted income statement with budgeted operating income for August. For those boxes in which you must enter subtracted or negative numbers use a minus sign. Newport Inc. Budgeted Income Statement For the First Quarter Ending August 31 July August 18,000,000 First Quarter June Sales v $ 10,800,000 $ 14,400,000 43,200,000 Cost of goods sold v 8,228,000 10,000,000 24,698,400 6,470,400 х х х х Gross profit 4,329,600 6,172,000 8,000,000 8,000,000 18,501,600 Selling and administrative expenses: Selling expenses v Administrative expenses V $ 1,700,000 $ 2,000,000 2,300,000 6,000,000 х 550,000 550,000 550,000 1,650,000 х х х х Total selling and administrative expenses 2,250,000 2,550,000 2,850,000 7,650,000 х х х х Operating income v 2,079,600 3,622,000 5,150,000 10,851,600
Expert Answer:
Answer rating: 100% (QA)
JUST ADD NEGATIVE SIGN TO THE FIGURES TO BE SUBTRACTED COST OF GOODS SOLD BUDGET June July August Fi... View the full answer
Related Book For
Financial & Managerial Accounting
ISBN: 978-1337902663
15th edition
Authors: Carl Warren, Jefferson P. Jones, William B. Tayler
Posted Date:
Students also viewed these accounting questions
-
Newport Inc. gathered the following data for use in developing the budgets for the first quarter (June, July, August) of its fiscal year: a. Estimated sales at $36 per unit: June. . . . . . . . . . ....
-
Bellaire Inc. gathered the following data for use in developing the budgets for the first quarter (January, February, March) of its fiscal year: a. Estimated sales at $125 per unit: January . . . . ....
-
At the start of its fiscal year on October 1, Fox County reported the following (all dollar amounts in thousands): Fund balance: Committed for encumbrances............$200...
-
Controlling Program Flow w/i an ATM Using selection statements & loops to complete the following: Validate the user's PIN -- only allow them to attempt three (3) times before ending the program If...
-
A historian researching the influence of society on the spread of communicable disease began to speculate on what it would be like if AIDS had appeared at a different time. What differences might one...
-
What flags can be sent as arguments to setiosflag and resetiosflag functions? Explain file classification in terms of access of data. Explain stream operating modes with suitable examples. Explain...
-
How often do you think boards should evaluate their own performance? Why?
-
Below are various resources and activities for a social services agency that helps homeless people get housing. Required Indicate whether each of the following are likely to be unit-level or...
-
5 4.28 Lopez Company is considering replacing one of its old manufacturing machines. The old machine has a book value of $49,000 and a remaining useful life of five years. It can be sold now for...
-
Mary Janes Beauty Shop has recently invested money to add more equipment to enable more services to be offered at the shop. Given the following information evaluate their investment.
-
Provide feedback about your peer's chosen example and the message/commentary about technology being provided. What would you add to their analysis? Peer 1: I have chosen to discuss the popular...
-
You're planning your Spring Break vacation. You're not going to a domestic destination, so select any country outside the United States and see how the cost of a $3,000 vacation will translate to the...
-
Building A is 170 feet shorter than Building B. The total height of the two buildings is 1520 feet. Find the height of each building. What is the height of Building A? n (Simplify your answer. Type...
-
Ivanhoe Corporation's fiscal year ends on November 30. The following accounts are found in its job order cost accounting system for the first month of the new fiscal year. Other data: 1. 2. 3. 4. On...
-
During the coronavirus pandemic, global supply chain issues caused the supply of new cars to shift left. Which role did price play in the new car market?
-
There is another good Y, and goods X and Y are substitutes. What happens to the demand curve of good Y, when the price of good X goes up? What would have happened if the goods X and Y were...
-
Sarah purchased 100 shares of General Electric stock at a price of $65.33 three months ago. She sold all stocks today for $52.98. During the year the stock paid dividends of $3.66 per share. What is...
-
Prove the formula for (d/dx)(cos-1x) by the same method as for (d/dx)(sin-1x).
-
Milkrageous, Inc., a large, private dairy products company, is determining cost allocations for performance evaluation purposes. Company bonuses are based on cost containment, so accurate costing...
-
On the basis of the following data, the general manager of Hawkeye Shoes Inc. decided to discontinue Childrens Shoes because it reduced operating income by $30,000. What is the flaw in this decision,...
-
The units of an item available for sale during the year were as follows: There are 1,500 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine...
-
If total monthly fixed costs for a company were plotted on a graph for seven months, would the line drawn between the plotted points be parallel to the base or sloped? Explain why.
-
What is the simplest way to verify the accuracy of a breakeven calculation?
-
How is the contribution margin per unit used?
Study smarter with the SolutionInn App