Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting Tools For Business Decision Making

Authors: Jerry J. Weygandt, Paul D. Kimmel, Ibrahim M. Aly, Donald E. Kieso

6th Canadian Edition

1119731828, 9781119731825

More Books

Students also viewed these Accounting questions