Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Managerial Accounting Can anyone help me with these, and include the calculations in order for me not to hardcode the numbers because I need to

Managerial Accounting

Can anyone help me with these, and include the calculations in order for me not to hardcode the numbers because I need to use the excel formulas.

Thank you

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Sales Projections in Units January February March April May 22,896 30,913 41,258 51,637 62,724 Projected Sales Price/Unit $ 421.00 Monthly Projected Selling & Administrative Expenses Variable Cost/Unit $ 2.00 Fixed Costs $4,713 Production: Desired Ending Inventory Beginning Inventory (new business) 98.3% 0 1.8% Materials Desired Ending Inventory Number of Materials per Unit Projected Cost/Material Unit Beginning Inventory (new business) 18.00 $23.00 0 Direct Labor Time per Unit (in hours) Cost per Hour 2.00 $21.00 Manufacturing Overhead Variable Cost/Unit $2.00 Fixed Costs $19 SALES BUDGET January February March April Projected Sales in Units Selling Price per Unit Anticipated Sales Dollars SELLING & ADMINISTRATIVE (S&A) EXPENSE BUDGET January February March April Sales in Units Variable S&A Rate/Unit Anticipated Variable Costs Fixed S&A Costs Total Anticipated Selling & Administrative Costs PRODUCTION BUDGET January February March April Sales in Units Desired Ending Inventory in Units Total Units Needed Beginning Inventory Total Production in Units January February March April Units to be Produced Materials Per Unit Total Materials Needed Desired Ending Inventory In Materials Total Materials Needed Beginning Inventory Total Materials Needed to be Purchased Cost per Unit of Material Total Material Cost Materials Per Unit Cost per Unit of Material Cost of Material per Product DIRECT LABOR BUDGET January February March April Number of Units Produced Direct Labor Hours Per Unit Total Direct Labor Hours Needed Cost Per Direct Labor Hour Total Direct Labor Cost Direct Labor Hours Per Unit Cost Per Direct Labor Hour Cost of Direct Labor per Product MANUFACTURING OVERHEAD BUDGET January February March April Production in Units Variable OH Rate Per Unit Anticipated VOH Costs Fixed OH Costs Total Anticipated OH Costs Predetermined OH Rate Total Estimated OH Costs per DLH Total Estimated DLHs MOH per Unit: Predetermined MOH rate DLHs per Unit MOH per Unit of Product PRODUCT COST PER UNIT Amount Item Direct Materials Direct Labor Manufacturing Overhead Total Unit Cost PROJECTED INCOME STATEMENT January February March April Sales in Units Sales Revenue Cost of Goods Sold: Gross Profit (Margin) Selling and Administrative (Operating) Expenses Operating Income

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

101 Recipes For Audit In Psychiatry

Authors: Clare Oakley, Floriana Coccia, Neil Masson, Iain McKinnon, Meinou Simmons

1st Edition

1908020016, 978-1908020017

More Books

Students also viewed these Accounting questions