Homework Answers
Month Qty
Sales Budget Jan 20,609
Feb 26,521
Mar 27,815
Apr 49,644
May 47,350
Projected Sales Qty 1,71,939
Sales Price / Unit 198
In $
Sales Budget in $ 3,40,43,922
Add Answer to:
Excel 2010 Help 1) create sales budget 2) operating budget 3) production budget 4) material req...
Project #2 Sales Projections in Units January February March April May 13.402 45,819 44,164 53,722 52,482...
Project #2 Sales Projections in Units January February March April May 13.402 45,819 44,164 53,722 52,482 Projected Sales Price/Unit $ 450.00 Monthly Projected Selling & Administrative Expenses Variable Cost/Unit $16.00 Fixed Costs $5,519 Production: Desired Ending Inventory Beginning Inventory (new business) 59.0% 0 64.6% Materials Desired Ending Inventory Number of Materials per Unit Projected Cost/Material Unit Beginning Inventory (new business) 11.0 $23.00 0 Direct Labor Time per Unit (in hours) Cost per Hour 1.00 $21.00 Manufacturing Overhead Variable Cost/Unit $5.00...
create the initial documents for the master budget: • sales budget • production budget • direct...
create the initial documents for the master budget:
• sales budget
• production budget
• direct materials purchases budget
• direct labor budget
• overhead budget
• selling and administrative expense budget
• cash budget include a schedule of cash collections and
payments
• finished goods inventory calculation
Then, Create the following schedules, financial statements, and
calculations
A) Pro forma cost of goods manufactured
B) Pro forma Cost of goods sold- both financial and variable
cost basis
C) Pro forma...
Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer...
Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks. The wiring harness assemblies are sold to various truck manufacturers around the world. Projected sales in units for the coming five months are given below. January 10,000 February 10,500 March 13,100 April 16,000 May 18,500 The following data pertain to production policies and manufacturing specifications followed by Ponderosa: Finished goods inventory on January 1 is 900 units. The desired ending inventory for each...
I got the first two rows but I have no idea how to proceed from here....
I got the first two rows but I
have no idea how to proceed from here.
If possible please show work
Sales Projections in Units January February 11,769 42,939 31,306 55,150 63,699 March April May $ Projected Sales Price/Unit 498.00 Monthly Projected Selling & Administrative Expenses 5.00 Variable Cost/Unit $ $3,427 Fixed Costs Production: Desired Ending Inventory 65.8% Beginning Inventory (new business) 0 Materials Desired Ending Inventory 73.1% Number of Materials per Unit 9.00 $10.00 Projected Cost/Material Unit Beginning Inventory...
Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft...
Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: January 40,000 February 50,000 March 60,000 April 60,000 May 62,000 The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: Finished goods inventory on January 1 is 32,000 units, each costing $166.06. The desired ending inventory for each...
Please prepare a production budget with the following master budget information: Projected unit sales for each...
Please prepare a production budget with the following master budget information: Projected unit sales for each quarter for 2013 are as follows: Quarter 1 60,000 Quarter 2 70,000 Quarter 3 80,000 Quarter 4 65,000 The selling price is $500 per unit. All sales are on credit (no cash sales). 70% of all sales are collected within the quarter they are sold. The other 30% are collected in the following quarter. There are no bad debts. There is no beginning inventory...
Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft...
Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: January 40,000 February 50,000 March 60,000 April 60,000 May 62,000 The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: 1 a. Finished goods inventory on January 1 is 32,000 units, each costing $166.06. The desired ending inventory...
Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer...
Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks. The wiring harness assemblies are sold to various truck manufacturers around the world. Projected sales in units for the coming five months are given below. January 10,000 February 10,600 March 13,300 April 16,000 May 18,500 The following data pertain to production policies and manufacturing specifications followed by Ponderosa: Finished goods inventory on January 1 is 900 units. The desired ending inventory for each...
Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer...
Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks. The wiring harness assemblies are sold to various truck manufacturers around the world. Projected sales in units for the coming five months are given below. January 10,000 February 10,600 March 13,500 April 16,000 May 18,500 The following data pertain to production policies and manufacturing specifications followed by Ponderosa: Finished goods inventory on January 1 is 900 units. The desired ending inventory for each...
Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer...
Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks. The wiring harness assemblies are sold to various truck manufacturers around the world. Projected sales in units for the coming five months are given below. January 10,000 February 10,600 March 13,300 April 16,000 May 18,500 The following data pertain to production policies and manufacturing specifications followed by Ponderosa: Finished goods inventory on January 1 is 900 units. The desired ending inventory for each...
Project #2 Sales Projections in Units January February March April May 13.402 45,819 44,164 53,722 52,482 Projected Sales Price/Unit $ 450.00 Monthly Projected Selling & Administrative Expenses Variable Cost/Unit $16.00 Fixed Costs $5,519 Production: Desired Ending Inventory Beginning Inventory (new business) 59.0% 0 64.6% Materials Desired Ending Inventory Number of Materials per Unit Projected Cost/Material Unit Beginning Inventory (new business) 11.0 $23.00 0 Direct Labor Time per Unit (in hours) Cost per Hour 1.00 $21.00 Manufacturing Overhead Variable Cost/Unit $5.00...
create the initial documents for the master budget:
• sales budget
• production budget
• direct materials purchases budget
• direct labor budget
• overhead budget
• selling and administrative expense budget
• cash budget include a schedule of cash collections and
payments
• finished goods inventory calculation
Then, Create the following schedules, financial statements, and
calculations
A) Pro forma cost of goods manufactured
B) Pro forma Cost of goods sold- both financial and variable
cost basis
C) Pro forma...
I got the first two rows but I
have no idea how to proceed from here.
If possible please show work
Sales Projections in Units January February 11,769 42,939 31,306 55,150 63,699 March April May $ Projected Sales Price/Unit 498.00 Monthly Projected Selling & Administrative Expenses 5.00 Variable Cost/Unit $ $3,427 Fixed Costs Production: Desired Ending Inventory 65.8% Beginning Inventory (new business) 0 Materials Desired Ending Inventory 73.1% Number of Materials per Unit 9.00 $10.00 Projected Cost/Material Unit Beginning Inventory...
Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: January 40,000 February 50,000 March 60,000 April 60,000 May 62,000 The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: 1 a. Finished goods inventory on January 1 is 32,000 units, each costing $166.06. The desired ending inventory...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago