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...
1. Prepare the sales budget for the year. 2. Prepare the production budget for the year....
1. Prepare the sales budget for the
year.
2. Prepare the production budget for the year.
3. Prepare the direct materials budget for the year.
4. Prepare the direct labor budget for the year. (Round
Direct labor time per unit answers to 1 decimal place, e.g.
52.5.)
5. Prepare the budegeted multiple-step income statement for the
year. (Note: income taxes are not allocated to the
products).
Ayayai Inc. is preparing its annual budgets for the year ending December 31, 2017....
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...
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...
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...
Thunder Creek Company expects sales of 18,000 units in January 2018, 24,000 units in February, 30,000...
Thunder Creek Company expects sales of 18,000 units in January 2018, 24,000 units in February, 30,000 units in March, 34,000 in April, and 36,000 in May. The sales price is $34 per unit. Prepare a sales budget 2018 Budget #1: Sales Budget Feb Q1 Total Аpril Jan Mar May Budgeted units to be sold Sales price per unit Total Sales Thunder Creek wants to finish each month with 20 % of next month's sales in units. Prepare a production budget....
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...
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...
1. Prepare the sales budget for the
year.
2. Prepare the production budget for the year.
3. Prepare the direct materials budget for the year.
4. Prepare the direct labor budget for the year. (Round
Direct labor time per unit answers to 1 decimal place, e.g.
52.5.)
5. Prepare the budegeted multiple-step income statement for the
year. (Note: income taxes are not allocated to the
products).
Ayayai Inc. is preparing its annual budgets for the year ending December 31, 2017....
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...
Thunder Creek Company expects sales of 18,000 units in January 2018, 24,000 units in February, 30,000 units in March, 34,000 in April, and 36,000 in May. The sales price is $34 per unit. Prepare a sales budget 2018 Budget #1: Sales Budget Feb Q1 Total Аpril Jan Mar May Budgeted units to be sold Sales price per unit Total Sales Thunder Creek wants to finish each month with 20 % of next month's sales in units. Prepare a production budget....
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.
-
Calculate the volume integral of the function T=z^2 over the
tetrahedron with corners (0,0,0), (1,0,0), (0,1,0),...
asked 24 minutes ago -
I propose to you a game. You roll 2 dice. If the sum of the
numbers...
asked 1 hour ago -
Select the most likely lattice types for each of the following
salts: (a) BeF2; (b) CaO;...
asked 1 hour ago -
a
ball is thrown downward with velocity of 10m/s. calculate the final
velocity if it reaches...
asked 1 hour ago -
How many grams of ice at -15°C must be added to 705 grams of
water that...
asked 3 hours ago -
2. Balance sheet
The balance sheet provides a snapshot of the financial condition
of a company....
asked 3 hours ago -
In week 1 of the chemical equilibrium experiment, you and your
lab team will create a...
asked 4 hours ago -
Identify and describe five (5) characteristics of a good KM
measurement system. Be sure to include...
asked 4 hours ago -
What are at least five (5) workplace wellness best practices for
a successful wellness program? Explain...
asked 4 hours ago -
A pharmaceutical company is testing a new drug. Of the 110
people that received the drug,...
asked 4 hours ago -
Which of the following is NOT a mechanism for gene
regulation?
a. Phase variation in DNA....
asked 4 hours ago -
Which of the following is being applied when, under certain
conditions, the value recorded for an...
asked 4 hours ago