Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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 Rate

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

Securing And Auditing Data On DB2 For Z/Os

Authors: IBM Redbooks

1st Edition

0738432857, 978-0738432854

More Books

Students also viewed these Accounting questions

Question

Simplify. (-2xy)(-2x2) z

Answered: 1 week ago