Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 BudgetStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started