Homework Help is Here – Start Your Trial Now!
Business
Accounting
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

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question
100%
Input Data (USL) whic Budget Aprit con Muyunta) Juz (unita) Ty CITA) August ( Setu Preet Cash collection patter Gottesving months ex Cash payments for materiab Nent of purchase Following and Pretium requirements TEA TRINDAral per anni (lb) Kuwa J Dint labas baru per anst Direct laber rate per hour inlahy MOHD por DL hour FI MCHED per m Depreciation in Fixed MOHD Selling administrative costs variable At per un sold Fixed AA BORT par month Depuiuti in Find san voul Other cash outilows Cuola divisad paid out Fement partes May Equipament purvis June Desired shapiny story Finished Goods Raw Materials Cash (S) Beginning account balances - March 31 Cash (5) Accounts teceivable (5) iisdoods inventory FG cost per sair inventory (unit Raw Materials inventory Raw Materials (16) Accounts Payable (5) Land Buildings and equipment Accumulated Depreciation Common stock Retained cornings Budgeted DL hours Variable MOHD rate Total Variable MOHD Fixed MOHD Expense Total MOHD Expense Less: Depreciation Cash disbursements for MOHD M-OHD rate Product cost per unit Direct Materials Direct Labor Manufacturing Overhead Unit Product Cost Cost of Goods Sold (FIFO) Beg. FG inventory Add Cost of Goods Mig'd Good Available for Sale Less: Ending FG inventory Cost of Good Sold Budgeted sales in units Variable S&A per unit Total Variable S&A Total Fixed S&A Total S&A Expense Less: Depreciation Cash Disbursements for S&A Cash Balance, Beginning: Add: Receipts Cash Collections Total Cash Available Less Disbuerias- Direct Direct Labor Manufacturing Overhead Selling and Administrative Dividends Equipment Purchases Total Disbursements Excess (deficiency) of cash available: Financing: BOITOwing Repayments Interest Total Financing Cash Balance, endine Expected 3,500 4,300 3,000 2,500 150 00 5004 6004 4086 $10.00 316.00 $25,000 30.22 50.000 $12,000 $10,000 SIR 140 $27,000 2506 2000 3504 $25.000 132,000 30,150 410 32.200 4,600 5.000 $520,000 11.786,200 (5750,0000 $500.0cc $1.259.950 Yellow-u only cell referenc Liltic Angin lapanakers als Meet (TTA) Aprill Rungsted Saten (tisim)" Selling Price per uzat. April lulus Tiere Annin Flagmakers Pohodule of Needed Cash Colle(1) Account Recena De Buluice Apr Salex May Sale Jones Rules Tudi Canh Chalectionnes Aunty Rivable, June 20. Little Annin Flagmakers Pin Budges ated usine inventory THE N Beginning inventory Required Product O Little Annin Flagmakers Direct Materials Budget (USD) April Required Production in ant Raw Materials yrasit (lb.) Production Seeds (198) Add. Devitud vasting inventory Lecz Reganing inventory Rais Materials in by purchased Letal Cost of Kuw Aiuterials Little Anamn Flagnakers Schedule of Expected Cach Diebursemente for Material (USD) April Aday June Accounts Payable Deginning Dalanes Apr Purchases May Purchases June Purchases Letal Cash Disbursementa Materials Accounts Payable, June 305 Little Anin Flugmakers Direct Labor Budget (USD) Units to be produced Disper that I loves recoded Dr. eest per hour Tetal direct inbor cast Little Annin Flagmakers Manufacturing Overhead Budget (USD) April May June DLH Little Annin Flagmakers Unit Product Cost (USD) Quantity Cost Cost/unit Little Annin Flagmaker's Cost of Goods Sold Budget (USD) Units Cost unit Total Cost Little Annin Flagmakers Selling and Administrative Expense Budget (USD) April May June Little Annin Flagmakers Cash Budget (USD) May April Quarter CURTEAT July Qewwvt Quarter Quarter Quarter Quarter Quarter August
Transcribed Image Text:Input Data (USL) whic Budget Aprit con Muyunta) Juz (unita) Ty CITA) August ( Setu Preet Cash collection patter Gottesving months ex Cash payments for materiab Nent of purchase Following and Pretium requirements TEA TRINDAral per anni (lb) Kuwa J Dint labas baru per anst Direct laber rate per hour inlahy MOHD por DL hour FI MCHED per m Depreciation in Fixed MOHD Selling administrative costs variable At per un sold Fixed AA BORT par month Depuiuti in Find san voul Other cash outilows Cuola divisad paid out Fement partes May Equipament purvis June Desired shapiny story Finished Goods Raw Materials Cash (S) Beginning account balances - March 31 Cash (5) Accounts teceivable (5) iisdoods inventory FG cost per sair inventory (unit Raw Materials inventory Raw Materials (16) Accounts Payable (5) Land Buildings and equipment Accumulated Depreciation Common stock Retained cornings Budgeted DL hours Variable MOHD rate Total Variable MOHD Fixed MOHD Expense Total MOHD Expense Less: Depreciation Cash disbursements for MOHD M-OHD rate Product cost per unit Direct Materials Direct Labor Manufacturing Overhead Unit Product Cost Cost of Goods Sold (FIFO) Beg. FG inventory Add Cost of Goods Mig'd Good Available for Sale Less: Ending FG inventory Cost of Good Sold Budgeted sales in units Variable S&A per unit Total Variable S&A Total Fixed S&A Total S&A Expense Less: Depreciation Cash Disbursements for S&A Cash Balance, Beginning: Add: Receipts Cash Collections Total Cash Available Less Disbuerias- Direct Direct Labor Manufacturing Overhead Selling and Administrative Dividends Equipment Purchases Total Disbursements Excess (deficiency) of cash available: Financing: BOITOwing Repayments Interest Total Financing Cash Balance, endine Expected 3,500 4,300 3,000 2,500 150 00 5004 6004 4086 $10.00 316.00 $25,000 30.22 50.000 $12,000 $10,000 SIR 140 $27,000 2506 2000 3504 $25.000 132,000 30,150 410 32.200 4,600 5.000 $520,000 11.786,200 (5750,0000 $500.0cc $1.259.950 Yellow-u only cell referenc Liltic Angin lapanakers als Meet (TTA) Aprill Rungsted Saten (tisim)" Selling Price per uzat. April lulus Tiere Annin Flagmakers Pohodule of Needed Cash Colle(1) Account Recena De Buluice Apr Salex May Sale Jones Rules Tudi Canh Chalectionnes Aunty Rivable, June 20. Little Annin Flagmakers Pin Budges ated usine inventory THE N Beginning inventory Required Product O Little Annin Flagmakers Direct Materials Budget (USD) April Required Production in ant Raw Materials yrasit (lb.) Production Seeds (198) Add. Devitud vasting inventory Lecz Reganing inventory Rais Materials in by purchased Letal Cost of Kuw Aiuterials Little Anamn Flagnakers Schedule of Expected Cach Diebursemente for Material (USD) April Aday June Accounts Payable Deginning Dalanes Apr Purchases May Purchases June Purchases Letal Cash Disbursementa Materials Accounts Payable, June 305 Little Anin Flugmakers Direct Labor Budget (USD) Units to be produced Disper that I loves recoded Dr. eest per hour Tetal direct inbor cast Little Annin Flagmakers Manufacturing Overhead Budget (USD) April May June DLH Little Annin Flagmakers Unit Product Cost (USD) Quantity Cost Cost/unit Little Annin Flagmaker's Cost of Goods Sold Budget (USD) Units Cost unit Total Cost Little Annin Flagmakers Selling and Administrative Expense Budget (USD) April May June Little Annin Flagmakers Cash Budget (USD) May April Quarter CURTEAT July Qewwvt Quarter Quarter Quarter Quarter Quarter 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 Other cash outflows Cash dividends paid each month Equipment purchases May Equipment purchases June Desired ending inventory Finished Goods Raw Materials Cash (S) Beginning account balances - March 31 Cash (S) Accounts Receivable ($) Finished Goods inventory FG cost per unit FG inventory (units) Raw Materials inventory Raw Materials (lb) Accounts Payable ($) Land Buildings and equipment Accumulated Depreciation Common stock Retained earnings Expected 3,500 4,500 3,000 2,000 2,500 $ 130.00 45% 50% 5% 60% 40% 6 $ $ $ $ $ $ $10.00 $36.00 $12 $58,000 $25,000 $0.25 $50,000 $15,000 $16,000 $18,440 $27,600 0.7 25% 35% $25,000 63,800 132,000 30,750 $75 410 32,200 4,600 55,000 $520,000 $1,786,200 ($750,000) $500,000 $1,259,950 Little Annin Flagmakers Sales Budget (USD) May June April April (units) Little Annin Flagmakers Schedule of Expected Cash Collections (USD) April May June Little Annin Flagmakers Production Budget April May June Little Annin Flagmakers Direct Materials Budget (USD) April May June Little Annin Flagmakers Schedule of Expected Cash Disbursements for Material (USD) April May June Little Annin Flagmakers Direct Labor Budget (USD) April May 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 Required Production in units Raw Materials per unit (lbs.) Production Needs (lbs) Add: Desired ending inventory Total Needs Less: Beginning inventory Raw Materials to be purchased Cost of Raw Materials: Total Cost of Raw Materials Accounts Payable Beginning Balance April Purchases May Purchases June Purchases Total Cash Disbursements For Materials Accounts Payable, June 30: Units to be produced DL hours per unit Total DL hours needed DL cost per hour Total direct labor cost June Quarter Quarter Quarter Quarter Quarter Quarter July August
Transcribed Image Text: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 Other cash outflows Cash dividends paid each month Equipment purchases May Equipment purchases June Desired ending inventory Finished Goods Raw Materials Cash (S) Beginning account balances - March 31 Cash (S) Accounts Receivable ($) Finished Goods inventory FG cost per unit FG inventory (units) Raw Materials inventory Raw Materials (lb) Accounts Payable ($) Land Buildings and equipment Accumulated Depreciation Common stock Retained earnings Expected 3,500 4,500 3,000 2,000 2,500 $ 130.00 45% 50% 5% 60% 40% 6 $ $ $ $ $ $ $10.00 $36.00 $12 $58,000 $25,000 $0.25 $50,000 $15,000 $16,000 $18,440 $27,600 0.7 25% 35% $25,000 63,800 132,000 30,750 $75 410 32,200 4,600 55,000 $520,000 $1,786,200 ($750,000) $500,000 $1,259,950 Little Annin Flagmakers Sales Budget (USD) May June April April (units) Little Annin Flagmakers Schedule of Expected Cash Collections (USD) April May June Little Annin Flagmakers Production Budget April May June Little Annin Flagmakers Direct Materials Budget (USD) April May June Little Annin Flagmakers Schedule of Expected Cash Disbursements for Material (USD) April May June Little Annin Flagmakers Direct Labor Budget (USD) April May 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 Required Production in units Raw Materials per unit (lbs.) Production Needs (lbs) Add: Desired ending inventory Total Needs Less: Beginning inventory Raw Materials to be purchased Cost of Raw Materials: Total Cost of Raw Materials Accounts Payable Beginning Balance April Purchases May Purchases June Purchases Total Cash Disbursements For Materials Accounts Payable, June 30: Units to be produced DL hours per unit Total DL hours needed DL cost per hour Total direct labor cost June Quarter Quarter Quarter Quarter Quarter Quarter July August
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 6 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS