Input Data (USD) Budgeted sales April (units) May (units) June (units) July (units) August (units) Selling Price/unit Cash collection pattern Month of sale Following month Uncollectible Cash payments for materials Month of purchase Following month Production requirements Raw material per unit (lb) Raw mat. cost per lb Direct labor hours per unit Direct labor rate per hour Variable MOHD per DL hour Fixed MOHD per month Depreciation in Fixed MOHD Selling & administrative costs Variable S&A cost per unit sold Fixed S&A cost per month Depreciation in Fixed S&A cost S Expected 3,500 4,500 3,000 2,000 2,500 130.00 45% 50% 5% 60% 40% 6 $10.00 0.7 $36.00 $12 $58,000 $25,000 $0.25 $50,000 $15,000 Yellow-use only cell references Blue-may type numbers here Budgeted Sales (units): Selling Price per unit: Total Sales: Accounts Receivable Beginning Balance April Sales May Sales June Sales Total Cash Collections: Accounts Receivable, June 30: Budgeted Sales Add: Desired ending inventory Total Needs Less: Beginning inventory Required Production Little Annin Flagmakers Sales Budget (USD) April May June April (units) Little Annin Flagmakers Schedule of Expected Cash Collections (USD) April May June Little Annin Flagmakers Production Budget May April June Quarter Quarter Quarter July August
Input Data (USD) Budgeted sales April (units) May (units) June (units) July (units) August (units) Selling Price/unit Cash collection pattern Month of sale Following month Uncollectible Cash payments for materials Month of purchase Following month Production requirements Raw material per unit (lb) Raw mat. cost per lb Direct labor hours per unit Direct labor rate per hour Variable MOHD per DL hour Fixed MOHD per month Depreciation in Fixed MOHD Selling & administrative costs Variable S&A cost per unit sold Fixed S&A cost per month Depreciation in Fixed S&A cost S Expected 3,500 4,500 3,000 2,000 2,500 130.00 45% 50% 5% 60% 40% 6 $10.00 0.7 $36.00 $12 $58,000 $25,000 $0.25 $50,000 $15,000 Yellow-use only cell references Blue-may type numbers here Budgeted Sales (units): Selling Price per unit: Total Sales: Accounts Receivable Beginning Balance April Sales May Sales June Sales Total Cash Collections: Accounts Receivable, June 30: Budgeted Sales Add: Desired ending inventory Total Needs Less: Beginning inventory Required Production Little Annin Flagmakers Sales Budget (USD) April May June April (units) Little Annin Flagmakers Schedule of Expected Cash Collections (USD) April May June Little Annin Flagmakers Production Budget May April June Quarter Quarter Quarter July August
Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter9: Profit Planning And Flexible Budgets
Section: Chapter Questions
Problem 66P: Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the...
Related questions
Question
100%
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 6 images
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning