Problem 14-20A (Static) Preparing a cash budget LO 14-5 Fayette Medical Clinic has budgeted the following cash flows. January $240, 000 February $232,000 $272,000 March Cash receipts Cash payments For inventory purchases For SSA expenses 220, 000 62,000 164,000 64,000 190,000 54,000 Fayette Medical had a cash balance of $16,000 on January 1. The company desires to maintain a cash cushion of $10,000. Funds are assumed to be borrowed, in increments of $2,000, and repaid on the last day of each month; the interest rate is 1 percent per month. Repayments may be made in any amount available. Fayette pays its vendors on the last day of the month also. The company had a monthly $80,000 beginning balance in its line of credit liability account from last year's quarterly results. Required Prepare a cash budget. (Any repayments should be indicated with a minus sign. Round intermediate and final answers to the nearest whole dollar amounts.)
Q: A city needs a new pedestrian bridge over a local stream. The city uses an interest rate of 5%, and…
A: Net Present Value=(Present Value of Cash Inflows-Present Value of Cash Outflows)
Q: 9. Which of the following will not appear in a cash budget in the same month? A. Cash sales B.…
A: The cash budget is prepared to record cash receipts and cash payments made during the period.
Q: Music Incorporated planned and manufactured 259,500 units of its single product in 2022, its first…
A: SIMS COMPANY Variable Costing Income Statement Sales (209,500 units X $ 79 per unit) $…
Q: Computing and Recording Interest Capitaliza Bullock Company is constructing a building for its own…
A: Capitalized interest Capitalized interest term refers to the cost of borrowing to acquire or…
Q: Required Accounting Entry Nature of Transaction Source Document Account Debited Account Credited 1.…
A: Source document are the document are the document that reveals the sources of the transactions.…
Q: n from the separ ome of P Compa as follows: ial position acco ..... ...
A: Given The percent of non-controlling interest ownership in S Company as of December 31, 2019.
Q: Cash Loan Payable Office Equipment Unearned Rentals Accrued Salaries Meg Drawing Repair Income…
A: Introduction: Trial balance: At every month end all the final ledger accounts balances are posted in…
Q: Y Inc. is a wholly owned subsidiary of P Corporation. The following are excerpts from the 2019…
A: Net income attributable to parent company is the consolidated net income after taxes and after…
Q: 5. S1: Consolidated statements worksheet elimination of intercompany sales of inventory does affect…
A: Basic Concept of Consolidation of financial Statement.
Q: Income Statements For the Years Ended December 31 Increase/(Decrease) 20Υ7 20Y6 Amount Percent Fees…
A: Formula used: Increase / ( Decrease ) amount = 20Y7 value - 20Y6 value
Q: Prepare journal entries for the first year to record each 4. An entity received a grant of…
A: Accounting for Grant Grant is the amount received for the different activities which are involved…
Q: In March 2020, Jones Company purchased a Mercedes for use in its business at a cost of $73,000.…
A: Introduction:- In March 2020, Jones Company purchased a Mercedes for use in its business at a cost…
Q: Using the information in AA8, how much is the total amount of Retained Earnings? P 150,000 P 100,000…
A: Retained earnings means the amount that is left after paying all the expenses and amount that…
Q: Assuming the taxpayer is a CORPORATION, how much is the OSD and net taxable income using OSD?
A: Tax Tax refers to the compulsory payment made by individuals or corporations to the government.…
Q: AA, BB and CC are partners with capital balances of P392,000, P1,365,000 and P595,000 respectively,…
A: Let the amount to be contributed by DD is Y. Firm’s total capital including contribution of DD…
Q: Sherborne sold his rental house in California, for a sales price of $750,000. He recognized a…
A: The rise in the value of a financial instrument when this is sold is referred to as a capital gain.…
Q: Based on the following, calculate the costs of buying versus leasing a motor vehicle.
A: Solution:- Given, Down payment = $1,500 Security deposit = $500 Estimated value at end of loan =…
Q: Prepare Trial Balance $1,200 700 Cash Accounts Receivable Capital Withdrawals Service Fees Rent…
A: Trial Balance: Trial balance is a statement in which the closing balance of all ledger accounts are…
Q: Level 1 Chapter 14 - Section I - Exercise 17 Luis Schambach is shopping for a 15-year mortgage for…
A: Mortgage- The word “mortgage” refers to a loan used to acquire or maintain a home, land, or other…
Q: Machinery Purchased for 5 so0000 Accumulated depreciation value is 5 LO0OI0 Salá for $ 400000…
A: Introduction: Depreciation: Decreasing value of fixed assets over its useful life period called as…
Q: Ray, who is single and 22 years old, was unemployed for a few months during 2020. He earned $6,700…
A: Answer: Option A. $0
Q: he year 2010, U and N reported net income of P350,000 and P200,000 each respectiv
A: The explanation, data interpretation, and workings In the context of the given question, we are…
Q: Doreen Company determined that the amortization rate on Its patents Is unacceptably low due to…
A: Amortization- Internally generated intangible assets are not recognized and disclosed in a company's…
Q: DATE PARTICULARS DEBIT CREDIT P 200,000 40,000 Dec-01 Cash Equipment Candelaria Maugat, Capital To…
A: Journal Entries are posted into T-accounts. The balance of T-accounts are presented in the trial…
Q: lease term is 6 years, with equal annual rental payments of $3,933 at the beginning of each year.…
A: Lease Accounting
Q: Calculate the missing values and express the answers rounded to two decimal places. Rate of Amount…
A: Markup refers to an amount added to the cost price to ascertain the selling price of the product.
Q: Debt to Assets ratio? Current assets $22400 Net income $44500 Stockholders' Current liabilities…
A: Debt to asset ratio is a measure that is used to evaluate the portion of total assets that has been…
Q: How do "sales tax-free" days impact our government?
A: sale tax free day means there will be no tax on certain items for cetain period of times. all those…
Q: 14. Zelgius, Ike, and Greil are partners in an accounting firm. Their ending capital balances were:…
A: Answer) Calculation of Greil’s Share in Total Profits Greil’s share in Total Profits = Greil’s…
Q: Complete Shadee's budgeted income statement for the months of May and June. Required information…
A: Budgeted income statement.
Q: 13. Ranran, Sansan, and Tantan are forming a new partnership. The following are their contributions:…
A: The partners can invest into the business in cash or non cash assets form. The liabilities…
Q: 2. If HHC has $1,100 cash, $400 of government Treasury bills purchased four months ago, and $770 of…
A: Cash and Cash equivalents Cash and cash equivalents refer to those items that are either in the form…
Q: r 31, 2019 consolidated Statement of financial position. Using the same information, determine the…
A: As per the given information in the above question we must determine the carrying amount of the…
Q: The following data were gathered to use in reconciling the bank account of Donovan Company: Balance…
A: Bank reconciliation statement is prepared with a view to reconcile the cash balance as per entity's…
Q: or each transaction indicate whether the assets, liabilities, or owner’s equity increased (I),…
A: The business transactions effects two or more accounts of the business effecting accounting equation…
Q: High-Low Method, Cost FormulasThe controller of the South Charleston plant of Ravinia, Inc.,…
A: The high-low technique is a cost accounting system that divides mixed expenses into variable costs.…
Q: Melvin Indecision has difficulty deciding whether to put his savings in Mystic Bank or Four Rivers…
A: Computation of the interest earned at the end of Melvin's investment period at each bank are as…
Q: Using the annual cost data below, if industry considering producing 7,500 units per year, determine…
A: W.N. 1 Calculation of Depreciation per Year Description Project A Project B…
Q: he image belo
A: Consolidated Statement: Consolidated statement is the accounting report of both the parent company…
Q: A company manufactures three related, but different, products. These are dishwashers, washing…
A: Direct labor variance reflects the difference between the actual cost incurred by the company on…
Q: Ms. Ligaya wants to buy her dream car. However, she does not have enough money to pay for ₱5,000,000…
A: The question is based on the concept of Financial Management.
Q: a. Using the information provided in the image below, determine the carrying amount of the inventory…
A: As per the given information in the above question we must determine the carrying amount of the…
Q: The following lots of Commodity Z were available for sale during the year. Beginning inventory 10…
A: Introduction: LIFO: LIFO stands for Last in First out. Which means last received inventory to be…
Q: 3y completing the table given below, and then applying the relevant formulae, determine the linear…
A: As per our protocol we provide solution to the one question only but as you have asked two questions…
Q: Effect of Stock Split Yeoman Grill Restaurant Corporation wholesales ovens and ranges to restaurants…
A: Introduction: Stock Split: Splitting of shares face value in to parts called Stock split. The Market…
Q: Exercise 10-24 (Algo) Interest capitalization [L010-7] On January 1, 2021, the Highlands Company…
A: Expenditure×Weight=Average
Q: Sales revenue is $ 500000 , Variable costs are 30 % of sales revenue and fixed costs are $ 200000 ,…
A: Formula: Net income = Revenues - Expenses.
Q: Home ownership has other expenses, including taxes, homeowner's insurance and utilities. The annual…
A: Amount borrowed = $145,000 a) Annual property tax = 1% of amount borrowed = $145,000×1%=$1,450…
Q: The following information concerns production in the Baking Department for December. All direct…
A: The equivalent units are calculated on the basis of percentage of the work completed during the…
Variance Analysis
In layman's terms, variance analysis is an analysis of a difference between planned and actual behavior. Variance analysis is mainly used by the companies to maintain a control over a business. After analyzing differences, companies find the reasons for the variance so that the necessary steps should be taken to correct that variance.
Standard Costing
The standard cost system is the expected cost per unit product manufactured and it helps in estimating the deviations and controlling them as well as fixing the selling price of the product. For example, it helps to plan the cost for the coming year on the various expenses.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- Budgeted income statement and supporting budgets The, budget director of Feathered Friends Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for December 2016: a. Estimated .sales for December: Bird house 3,200 units at 50 per unit Bird feeder 3,000 units at 70 per unit b. Estimated inventories at December 1: Direct materials: Finished products: Wood 200 ft Bird house....... 320 units at 27 per unit Plastic 240 lbs. Bird feeder....... 270 units at 40 per unit c. Desired inventories at December 31: Direct materials: Finished products: Wood 220 ft Bird house....... 290 units at 27 per unit Plastic 200 lbs. Bird feeder....... 250 units at 41 per unit d. Direct materials used in production: In manufacture of Bird House: In manufacture of Bird Feeder: Wood 0.80 ft. per unit of product Wood........... 1.20 ft per unit of product Plastic 050 lb. per unit of product Plastic........... 0.75 lb. per unit of product e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Wood 7.00 per ft. Plastic................. 1.00 per lb. f. Direct labor requirements: Bird House: Fabrication Department 0.20 hr. at 16 per hr. Assembly Department 0.30 hr. at 12 per hr. Bird Feeder: Fabrication Department 0.40 hr. at 16 per hr. Assembly Department 0.35 hr. at 12 per hr. g. Estimated factory overhead costs for December. Indirect factory wages 75,000 Power and light 6,000 Depreciation of plant and equipment 23,000 Insurance and property tax 5,000 h. Estimated operating expenses for December: Sales salaries expense 70,000 Advertising expense 18,000 Office salaries expense 21,000 Depreciation expenseoffice equipment 600 Telephone expenseselling 550 Telephone expenseadministrative 250 Travel expenseselling 4,000 Office supplies expense 200 Miscellaneous administrative expense 400 i. Estimated other income and expense for December: Interest revenue 200 Interest expense 122 j. Estimated lax rate: 30% Instructions 1. Prepare a sales budget for December. 2. Prepare a production budget for December. 3. Prepare a direct materials purchases budget for December. 4. Prepare a direct labor cost budget for December. 5. Prepare a factory overhead cost budget for December. 6. Prepare a cost of goods sold budget for December. Work in process at the beginning of December is estimated to be 29,000 and work in process at the end of December is estimated to be 35,400. 7. Prepare a selling and administrative expenses budget for December. 8. Prepare a budgeted income statement for December.Budgeted income statement and supporting budgets The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January: a. Estimated sales for January: Birdhouse 6.000 units at 55 per unit Bird feeder 4,500 units at 75 per unit b. Estimated inventories at January 1: Direct materials: Finished products: Wood 220 ft. Birdhouse 300 units at 23 per unit Plastic 250 lb. Bird feeder 240 units at 34 per unit c. Desired inventories at January 31: Direct materials: Finished products: Wood 180 ft. Birdhouse 340 units at 23 per unit Plastic 210 lb. Bird feeder 200 units at 34 per unit d. Direct materials used in production: In manufacture of Birdhouse: In manufacture of Bird Feeder: Wood ... 0.80 ft. per unit of product Wood 1.20 ft. per unitof product Plastic . . 0.50 lb. per unit of product Plastic 0.75 lb. per unit of product e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Wood 8.00 per ft. Plastic 1.20 per lb. f. f. Direct labor requirements: Birdhouse: Fabrication Department 0.20 hr. at15 per hr. Assembly Department 0.30 hr. at 12 per hr. Bird Feeder: Fabrication Department 0.40 hr. at15 per hr. Assembly Department 0.35 hr. at 12 per hr. g. Estimated factory overhead costs for January: Indirect factory wages 80,000 Power and light 8,000 Depreciation of plant and equipment 25,000 Insurance and property tax 2,000 h. Estimated operating expenses for January: Sales salaries expense 90,000 Advertising expense 20,000 Office salaries expense 18,000 Depredation expenseoffice equipment 800 Telephone expenseselling 500 Telephone expenseadministrative 200 Travel expenseselling 5,000 Office supplies expense 250 Miscellaneous administrative expense 450 i. Estimated other income and expense for January: Interest revenue 300 Interest expense 224 j. Estimated tax rate: 30% Instructions 1. Prepare a sales budget for January. 2. Prepare a production budget for January. 3. Prepare a direct materials purchases budget for January. 4. Prepare a direct labor cost budget for January. 5. Prepare a factory overhead cost budget for January. 6. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be 29,000, and work in process at the end of January is estimated to be 35,400. 7. Prepare a selling and administrative expenses budget for January. 8. Prepare a budgeted income statement for January.Budgeted income statement and supporting budgets The budget director of Gold Medal Athletic Co., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for March 2016: a. Estimated sales for March: Batting helmet 1,200 units at 40 per unit Football helmet 6,500 units at 160 per unit b. Estimated inventories at March 1: Direct materials: Finished products: Plastic 90 lbs. Batting helmet........ 40 units at 25 per unit Foam lining 80 lbs. Football helmet....... 240 units at 77 per unit c. Desired inventories at March 31: Direct materials: Finished products: Plastic50 lbs. Batting helmet......... 50 units at 25 per unit Foam lining65 lbs. Football helmet........ 220 units at 78 per unit d. Direct materials used in production: In manufacture of batting helmet: Plastic 1.20 lbs. per unit of product Foam lining 0.50 lb. per unit of product In manufacture of football helmet: Plastic 3.50 lbs. per unit of product Foam lining 1.50 lbs. per unit of product e. Anticipated cost of purchases and beginning and ending inventor) of direct materials: Plastic 6.00 per lb. Foam lining 4.00 per lb. f. Direct labor requirements: Batting helmet: Molding Department 0.20 hr. at 20 per hr. Assembly Department 0.50 hr. at 14 per hr. Football helmet: Molding Department 0.50 hr. at 20 per hr. Assembly Department 1.80 hrs. at 14 per hr. g. Estimated factory overhead costs for March: Indirect factory wages 86,000 Power and light 4,000 Depreciation of plant and equipment 12,000 Insurance and property tax 2,300 h. Estimated operating expenses for March: Sales salaries expense 184,300 Advertising expense 87,200 Office salaries expense 32,400 Depreciation expenseoffice equipment 3,800 Telephone expenseselling 5,800 Telephone expenseadministrative 1,200 Travel expense-selling 9,000 Office supplies expense 1,100 Miscellaneous administrative expense 1,000 i. Estimated other income and expense for March: Interest revenue 940 Interest expense 872 j. Estimated tax rate: 30% Instructions 1. Prepare a sales budget for March. 2. Prepare a production budget for March. 3. Prepare a direct materials purchases budget for March. 4. Prepare a direct labor cost budget for March. 5. Prepare a factory overhead cost budget for March. 6. Prepare a cost of goods sold budget for March. Work in process at the beginning of March is estimated to be 15,300, and work in process at the end of March is desired to be 14,800. 7. Prepare a selling and administrative expenses budget for March. 8. Prepare a budgeted income statement for March.
- Budgeted income statement and balance sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 2017, the following tentative trial balance as of December 31, 2016, is prepared by the Accounting Department of Regina Soap Co.: Cash............................................................. 85,000 Accounts Receivable............................................... 125,600 Finished Goods................................................... 69,300 Work in Process................................................... 32,500 Materials......................................................... 48,900 Prepaid Expenses................................................. 2,600 Plant and Equipment.............................................. 325,000 Accumulated Depreciation Plant and Equipment.................. 156,200 Accounts Payable................................................. 62,000 Common Stock, 10 par........................................... 180,000 Retained Earnings................................................. 290,700 688,900 688,900 Factory output and sales for 2017 are expected to total 200,000 units of product, which are to be sold at 5.00 per unit. The quantities and costs of the inventories at December 31, 2017, are expected to remain unchanged from the balances at The beginning of the year. Budget estimates of manufacturing costs and operating expenses for the year are summarized as follows: Estimated Costs and Expenses Cost of goods manufactured and sold: Fixed (Total for Year) Direct materials................................................ 1.10 Direct labor.................................................... 0.65 Factory overhead: Depreciation of plant and equipment.......................... 40,000 Other factory overhead....................................... 12,000 0.40 Selling expenses: Sales salaries and commissions.................................. 46,000 0.45 Advertising.................................................... 64,000 Miscellaneous selling expense.................................. 6,000 0.25 Administrative expenses: Office and officers salaries...................................... 72,400 0.12 Supplies....................................................... 5,000 0.10 Miscellaneous administrative expense........................... 4,000 0.05 Balances, of accounts receivable, prepaid expenses, and accounts payable at the end of the year are not expected to differ significantly from the beginning balances. Federal income tax of 30,000 on 2017 taxable income will be paid during 2017. Regular quarterly cash dividends of 0.15 per share are expected to be declared and paid in March, June, September, and December on 18,000 shares of common stock outstanding. It is anticipated that fixed assets will be purchased for 75,000 cash in May. Instructions 1. Prepare a budgeted income statement for 2017. 2. Prepare a budgeted balance sheet as of December 31, 2017, with supporting calculations.Budgeted income statement and supporting budgets The budget director of Gold Medal Athletic Co., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income .statement for March: a. Estimated sales for March: Batting helmet 1,200 units at 40 per unit Football helmet 6,500 units at 160 per unit b. Estimated inventories at March 1: Direct materials: Finished products: Plastic 90 lb. Batting helmet 40 units at 25 per unit Foam lining 80 lb. Football helmet 240 units at 77 per unit c. Desired inventories at March 31: Direct materials: Finished products: Plastic 50 lb. Batting helmet 50 units at 25 per unit Foam lining 65 lb. Football helmet 220 its at 78 per unit d. Direct materials used in production: In manufacture of batting helmet: Plastic 1.20 lb. per unit of product Foam lining 0.50 lb. per unit of product In manufacture of football helmet: Plastic 3.50 lb. per unit of product Foam lining 1.50lb. per unit of product e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Plastic 6.00 per lb. Foam lining 4.00 per lb. f. Direct labor requirements: Batting helmet: Molding Department 0.20 hr. at 20 per hr. Assembly Department 0.50 hr. at 14 per hr. Football helmet: Molding Department 0.50 hr. at 20 per hr. Assembly Department l.80 hrs.at 14perhr. g. Estimated factory overhead costs for March: Indirect factory wages 86,000 Power and light 4,000 Depreciation of plant and equipment 12,000 Insurance and property tax 2300 h. Estimated operating for March: Sales salaries expense 184,300 Advertising expense 87,200 Office salaries expense 32,400 Depreciation expenseoffice equipment 3,800 Telephone expenseselling 5,800 Telephone expenseadministrative 1,200 Travel expenseselling 9,000 Office supplies expense 1,100 Miscellaneous administrative expense 1,000 i. Estimated other income and expense for March: Interest Revenue 940 Interest Expense 872 j. Estimated tax rate: 30% Instructions 1.Prepare a sales budget for March. 2.Prepare a production budget for March. 3. Prepare a direct materials purchases budget for March. 4. Prepare a direct labor cost budget for March. 5. Prepare a factory overhead cost budget for March. 6. Prepare a cost of goods sold budget for March. Work in process at the beginning of March is estimated to be 15,300, and work in process at the end of March is desired to be 14,800. 7.Prepare a selling and administrative expenses budget for March. 8.Prepare a budgeted income statement for March. 9.Prepare a factory overhead cost budget for March. 10.Prepare a cost of goods .sold budget for March. Work in process at the beginning of March is estimated to the 115,300, and work in process at the end of March is desired to be 14,800. 11.Prepare a selling and administrative expenses budget for March. 12.Prepare a budgeted income statement for March.Budgeted income statement and supporting budgets The budget director of Gold Medal Athletic Co., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income .statement for March: a. Estimated sales for March: Batting helmet 1,200 units at 40 per unit Football helmet 6,500 units at 160 per unit b. Estimated inventories at March 1: Direct materials: Finished products: Plastic 90 lb. Batting helmet 40 units at 25 per unit Foam lining 80 lb. Football helmet 240 units at 77 per unit c. Desired inventories at March 31: Direct materials: Finished products: Plastic 50 lb. Batting helmet 50 units at 25 per unit Foam lining 65 lb. Football helmet 220 its at 78 per unit d. Direct materials used in production: In manufacture of batting helmet: Plastic 1.20 lb. per unit of product Foam lining 0.50 lb. per unit of product In manufacture of football helmet: Plastic 3.50 lb. per unit of product Foam lining 1.50lb. per unit of product e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Plastic 6.00 per lb. Foam lining 4.00 per lb. f. Direct labor requirements: Batting helmet: Molding Department 0.20 hr. at 20 per hr. Assembly Department 0.50 hr. at 14 per hr. Football helmet: Molding Department 0.50 hr. at 20 per hr. Assembly Department l.80 hrs.at 14perhr. g. Estimated factory overhead costs for March: Indirect factory wages 86,000 Power and light 4,000 Depreciation of plant and equipment 12,000 Insurance and property tax 2300 h. Estimated operating for March: Sales salaries expense 184,300 Advertising expense 87,200 Office salaries expense 32,400 Depreciation expenseoffice equipment 3,800 Telephone expenseselling 5,800 Telephone expenseadministrative 1,200 Travel expenseselling 9,000 Office supplies expense 1,100 Miscellaneous administrative expense 1,000 i. Estimated other income and expense for March: Interest Revenue 940 Interest Expense 872 j. Estimated tax rate: 30% Instructions 1.Prepare a sales budget for March. 2.Prepare a production budget for March. 3. Prepare a direct materials purchases budget for March. 4. Prepare a direct labor cost budget for March. 5. Prepare a factory overhead cost budget for March. 6. Prepare a cost of goods sold budget for March. Work in process at the beginning of March is estimated to be 15,300, and work in process at the end of March is desired to be 14,800. 7.Prepare a selling and administrative expenses budget for March. 8.Prepare a budgeted income statement for March. 9.Prepare a factory overhead cost budget for March. 10.Prepare a cost of goods .sold budget for March. Work in process at the beginning of March is estimated to the 115,300, and work in process at the end of March is desired to be 14,800. 11.Prepare a selling and administrative expenses budget for March. 12.Prepare a budgeted income statement for March.