# Please use excel equations to answer the income statement amounts and other amounts Final Answers Here...

###### Question:

please use excel equations to answer the income statement amounts and other amounts

Final Answers Here Please Income Statement Amounts Other Amounts 5 Units Sold * Selling Price 7 Pounds Per Direct Materials 3 DL Per OH Rate • Current Finished 7 Target Finished 2 Current DM 3 Target DM 4 Cost Per DM 5 Cost Per DL 2,500 $100.00 3.00 2.00$ 15.00 300 200 100 200 $5.00$ 20.00 Sales Direct Materials Direct Labor Overhead Production Budget Direct Materials Budget (in pounds) Direct Labor budget (in hours) Total Costs Gross Profit 90 Jensen Manufacturing has the following information relating to their master budget for 2020 -0 Units Sold Selling Price Pounds of Direct Materials Per Unit Manufactured DL Hours Per Unit Manufactured OH Rate Per DL Hour Current Inventory of Finished Product Target Inventory of Finished Product Current Inventory of Direct Materials E6 Target Inventory of Direct Materials 7 Cost per Pound of Direct Material - Cost per Direct Labor Hour 2,500 units $100 per unit 3 pounds 2 hours$15 per hour 300 units 200 units 100 pounds 200 pounds $5.00 per pound$20.00 per hour 0 Required On the spreadsheet provided, prepare the following: • Sales Budget • Production Budget in Units 249 29 • Direct Materials Budget in Units and Dollars • Direct Labor Budget in Hours and Dollars • Overhead Budget in Dollars • Gross Profit Budget

#### Similar Solved Questions

##### Do the two questions *Question 221: Microscope A crude symmetric hand held microscope consists of two...
do the two questions *Question 221: Microscope A crude symmetric hand held microscope consists of two converging lenses each of focal length 5.0 cm fastened in the ends of a tube 40 cm long. What is the overall angular magnification of the microscope? (Use a near point of 25 cm.) Select one: O a...
##### Listed below are the overhead widths (in cm) of seals measured from photographs and the weights...
Listed below are the overhead widths (in cm) of seals measured from photographs and the weights (in kg) of the seals. Construct a scatterplot, find the value of the linear correlation coefficient r, and find the critical values of r using a = 0.05. Is there sufficient evidence to conclude that there...
##### 1/1 Question 8 The healthy knee normally has range of motion (ROM) of 135 degrees. If...
1/1 Question 8 The healthy knee normally has range of motion (ROM) of 135 degrees. If the lateral malleolus is 51 cm distal to the knee joint center, what linear distance can it move? 51 cm 68.85 cm Correct! 1.2 m 240 cm Question 2 1/1 pts...
##### 1. (15 points) Use the Euclidean Algorithm to find GCD(344,72). Note: You must show all major...
1. (15 points) Use the Euclidean Algorithm to find GCD(344,72). Note: You must show all major steps of the algorithm to derive your answer....
##### 36 5. In this exercise you are to develop the equation that relates temperature on the...
36 5. In this exercise you are to develop the equation that relates temperature on the Fahrenheit scale (T), to temperature on theKelvinscale (K). You may want to prepare this plot on a full sheet of graph paper. Use Fahrenbeit temperature as the independent variable. (a) Prepare a plot of these dat...
##### How do you simplify -[ 4- ( 5- x ) ]?
How do you simplify -[ 4- ( 5- x ) ]?...
##### Obtain or compute the following quantities. (a) F0.05, 2, 9 (Round your answer to two decimal...
Obtain or compute the following quantities. (a) F0.05, 2, 9 (Round your answer to two decimal places.) (b) F0.05, 9,2 (Round your answer to two decimal places.) (c) F0.95, 2,9 (Round your answer to three decimal places.) (d) F0.95, 9, 2 (Round your answer to three decimal places.) (e) the 99th perce...
##### In the experiment, you hang an aluminum block in air on a force sensor, and obtain...
In the experiment, you hang an aluminum block in air on a force sensor, and obtain a reading of 5.8N. You then hang the block in water, the force sensor reading becomes 3.5N. How much buoyance force, in unit of N, does the block experience?...
##### Draw an alkyl bromide with proper stereochemistry that can be used to sythesize the given alkene...
Draw an alkyl bromide with proper stereochemistry that can be used to sythesize the given alkene as the exclusive product via an E2 reaction....
##### Suppose that an economy's labor became more productive between year 1 and year 2. We could...
Suppose that an economy's labor became more productive between year 1 and year 2. We could conclude that this economy's Multiple Choice real GDP remained constant. capital stock increased by 3%. production possibilities frontier shifted inward. production possibilities frontier shifted outwa...
##### Remaining Time: 1 hour, 07 minutes, 48 seconds. Question Completion Status: 1 2 3 4 5...
Remaining Time: 1 hour, 07 minutes, 48 seconds. Question Completion Status: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 > Moving to another question will save this response. Question 17 of 22 > Question 17 2.5 points Save Answer A stationary man hears a sound of frequency 447 Hz c...