Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Have an assignment on the master budget and can't seem to figure out how to create the following 3 budgets: Overhead Budget for the 1
Have an assignment on the master budget and can't seem to figure out how to create the following 3 budgets:
Overhead Budget for the 1st quarter (January-March) Overall Cash Budget for the 1st quarter (January-March) Statement of Cash Flows for the quarter ended March 31, 2016
Below is an image of the necessary information to create the master budget.
Thanks in advance! (:
This page illustrates all assumptions needed to create the master budget, income statement and statement of cash flows. These assumptions have been approved by the CFO. You will use them to create the master budget for January, February, March and in total for the first quarter. January February March April May Unit Sales 26,000 26,000 27,500 27,750 28,000 Sales Price S10 Desired Ending Inventory for Finished Goods 20% of next month's sales in units Desired Ending Inventory for Material Units 10% of next month's materials needed for production Cost of one b of materials (1 b 1 material unit $0.35 4 Units of Direct Materials to make one unit 15 Minutes of Direct Labor to make one unit Direct Labor Costs per Hour S15 135% Overhead Costs percentage of Direct Labor Minimum cash balance (Assume you start with this S10,000.00 Cash collections in month of sale 70% 25% Cash collections in first month after sale 5% Cash collections in second month after sale 60% Cash Payments in month of purchase 40% Cash Payments in the first month after purch Selling Costs per month (for cash budget) 11,000.00 Administrative Costs per month (for cash budget) Is 14,000.00 12% Annual Interest Rate for Letter of Credit 4% Annual Interest Rate Earned on Excess Cash Sales Revenue for November S250,000 Sales Revenue for December S260,000 Material Purchases for November S22,000 S22,000 Material Purchases for December Depreciation Expense for the quarter (Operating Exp) $5,500 Income Tax RateStep 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