Master Budget Based on the following information, prepare the Master Budget for Brindle Arts, Inc. for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Master Budget Based on the following information, prepare the Master Budget for Brindle Arts, Inc. for Quarter 4, 2020 Beginning of quarter balances: Cash Accounts Receivable Finished Goods Inventory (pieces of art) Raw Materials inventory (kits) Buildings and equipment Accounts Payable Common Stock Retained Earnings Actual and budgeted sales data (pieces of art): October Sept. (act.) 3,250 Artwork is sold for $200 each. 3,000 Selling price per piece of situad $ November 3,500 200 $ $ $ $ $ 150,000 260,000 300 610 350,000 50,294 150,000 52,431 December 4,500 January 2,100 February 3,300 Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at the beginning of the quarter are a result of September's credit sales. Sales: Cash 60% Credit 40% The finished goods inventory on hand at the end of each month must equal 10% of the next month's sales. of next month's sales Finished Goods inventory 10% The raw materials inventory on hand at the end of each month must equal 10% of the following month's production needs for raw materials. Raw materials inventory: 10% of next month's production needs Rawm materials needed per unit of artwork Raw materials cost: $ 32.50 per finishing kit 75% of each raw materials purchases is paid for in the month of purchase; the other 25% is paid in the following month. The accounts payable at the beginning of the quarter are the result of September raw materials purchases. Purchases: Month of 75% Month after 25% Manufacturing and Selling and Administrative costs: Variable cost per unit: Direct $ matoriale Direct labor $ Var. MOH $ Var. S&A $ 65.00 30.00 15.00 10.00 Office equipment 5,000 2 finishing kits in October Fixed costs per month: Manufacturing OH Depreciation - Manuf. Selling and Admin. Depreciation - S&A Office equipment costing $5,000 will be purchased for cash in October and new equipment will be purchased in December for $8,000. Equipment purchase $ $ $ $ 170,000 180,000 125,000 75,000 8,000 in December Management would like to maintain a minimum cash balance of at least $50,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter. Minimum cash on hand $ Borrow in $ Interest (no compounding) Use the data above, complete the following statements and schedules for the Quarter 4, 2020: Schedule of expected cash collections: Cash Sales Credit sales Total cash collected Production budget Budgeted unit sales Add desired ending finished goods inventory Total needs Less beginning finished goods inventory Required production in units Direct materials budget Required production in units of finished goods (gift baskets) Units of raw materials needed to meet production (bags of snack mix) Add desired units of ending raw materials inventory (bags of snack mix) Total units of raw materials needed (bags of snack mix) 50,000 1.000 increments 1% October October October November November November December December December Quarter January Quarter Bonus (up to 2pts) January Accounts Receivable at the end of the quarter Units of raw materials to be purchased (bags of snack mix) Cost of raw materials to be purchased (bags of snack mix) Schedule of expected cash disbursements for inventory purchases: October September purchases October purchases November purchases December purchases Total cash disbursements for purchases Direct labor budget Cash Disbursed Required production, in units Total direct labor cost Cash budget Beginning Cash balance Add cash collections Total cash available Less total cash disbursements: Purchases Direct labor Variable manufacturing OH Fixed manufacturing OH October October November November November December December December Quarter Quarter Quarter Bonus (up to 2pts) Accounts Payable at the end of the quarter Variable S&A Fixed S&A Equipment Total cash disbursements Cash available before financing Financing: Borrowings (at beginnings of quarters) Repayments Interest Total Financing Ending Cash balance Prepare an absorption costing income statement for the quarter ending December 31. Sales revenue Less variable costs: Cost of goods sold Selling and admin. Total variable costs Contribution margin Less fixed costs: Manufacturing overhead Selling and admin. Total fixed costs Operating income Less interest expense Het income (loss) Brindle Arts,Inc. Income Statement For Quarter Ended December 31 Prepare a balance sheet as of December 31. Brindle Arts,Inc. Balance Sheet As of December 31 Assets Current Assets: Cash Accounts Receivable Inventory Total Current Assets Buildings and equipment - net Total Assets Liabilities and Stockholders' Equity Current Liabilities: Accounts Payable Stockholders' equity: Common Stock Retained Earnings Total Liabilities and Stockholders' Equity Bonus (up to 3pts) Master Budget Based on the following information, prepare the Master Budget for Brindle Arts, Inc. for Quarter 4, 2020 Beginning of quarter balances: Cash Accounts Receivable Finished Goods Inventory (pieces of art) Raw Materials inventory (kits) Buildings and equipment Accounts Payable Common Stock Retained Earnings Actual and budgeted sales data (pieces of art): October Sept. (act.) 3,250 Artwork is sold for $200 each. 3,000 Selling price per piece of situad $ November 3,500 200 $ $ $ $ $ 150,000 260,000 300 610 350,000 50,294 150,000 52,431 December 4,500 January 2,100 February 3,300 Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at the beginning of the quarter are a result of September's credit sales. Sales: Cash 60% Credit 40% The finished goods inventory on hand at the end of each month must equal 10% of the next month's sales. of next month's sales Finished Goods inventory 10% The raw materials inventory on hand at the end of each month must equal 10% of the following month's production needs for raw materials. Raw materials inventory: 10% of next month's production needs Rawm materials needed per unit of artwork Raw materials cost: $ 32.50 per finishing kit 75% of each raw materials purchases is paid for in the month of purchase; the other 25% is paid in the following month. The accounts payable at the beginning of the quarter are the result of September raw materials purchases. Purchases: Month of 75% Month after 25% Manufacturing and Selling and Administrative costs: Variable cost per unit: Direct $ matoriale Direct labor $ Var. MOH $ Var. S&A $ 65.00 30.00 15.00 10.00 Office equipment 5,000 2 finishing kits in October Fixed costs per month: Manufacturing OH Depreciation - Manuf. Selling and Admin. Depreciation - S&A Office equipment costing $5,000 will be purchased for cash in October and new equipment will be purchased in December for $8,000. Equipment purchase $ $ $ $ 170,000 180,000 125,000 75,000 8,000 in December Management would like to maintain a minimum cash balance of at least $50,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter. Minimum cash on hand $ Borrow in $ Interest (no compounding) Use the data above, complete the following statements and schedules for the Quarter 4, 2020: Schedule of expected cash collections: Cash Sales Credit sales Total cash collected Production budget Budgeted unit sales Add desired ending finished goods inventory Total needs Less beginning finished goods inventory Required production in units Direct materials budget Required production in units of finished goods (gift baskets) Units of raw materials needed to meet production (bags of snack mix) Add desired units of ending raw materials inventory (bags of snack mix) Total units of raw materials needed (bags of snack mix) 50,000 1.000 increments 1% October October October November November November December December December Quarter January Quarter Bonus (up to 2pts) January Accounts Receivable at the end of the quarter Units of raw materials to be purchased (bags of snack mix) Cost of raw materials to be purchased (bags of snack mix) Schedule of expected cash disbursements for inventory purchases: October September purchases October purchases November purchases December purchases Total cash disbursements for purchases Direct labor budget Cash Disbursed Required production, in units Total direct labor cost Cash budget Beginning Cash balance Add cash collections Total cash available Less total cash disbursements: Purchases Direct labor Variable manufacturing OH Fixed manufacturing OH October October November November November December December December Quarter Quarter Quarter Bonus (up to 2pts) Accounts Payable at the end of the quarter Variable S&A Fixed S&A Equipment Total cash disbursements Cash available before financing Financing: Borrowings (at beginnings of quarters) Repayments Interest Total Financing Ending Cash balance Prepare an absorption costing income statement for the quarter ending December 31. Sales revenue Less variable costs: Cost of goods sold Selling and admin. Total variable costs Contribution margin Less fixed costs: Manufacturing overhead Selling and admin. Total fixed costs Operating income Less interest expense Het income (loss) Brindle Arts,Inc. Income Statement For Quarter Ended December 31 Prepare a balance sheet as of December 31. Brindle Arts,Inc. Balance Sheet As of December 31 Assets Current Assets: Cash Accounts Receivable Inventory Total Current Assets Buildings and equipment - net Total Assets Liabilities and Stockholders' Equity Current Liabilities: Accounts Payable Stockholders' equity: Common Stock Retained Earnings Total Liabilities and Stockholders' Equity Bonus (up to 3pts)
Expert Answer:
Answer rating: 100% (QA)
To assist you further Ill need to go through each section stepbystep Since the question is large it would be helpful to focus on specific parts one at ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Prepare the current asset section based on the following alphabetized post-closing trial balance information at March 31, 2014, for Whiteagle Company: Account Accounts payable Accounts receivable...
-
A binomial probability model is to be based on the following index function model: y* = ? + ?d + ?, y = 1, if y* > 0, y = 0 otherwise. The only regress or, d, is a dummy variable. The data consist of...
-
Based on the following accounts, calculate (a) Net sales, (b) Cost of goods sold, (c) Gross profit, (d) Net income. Accounts Payable .................. $ 6,400 Operating Expenses .....................
-
The common stock of Scarlet Enterprises currently pays a quarterly dividend of $1.75 per share. The dividend is assumed to grow annually at a constant rate of 4.0%. The market beta for Scarlet...
-
How do the working trial balance, lead schedules, and detailed work papers articulate?
-
What is the Black-Scholes-Merton price of European call and put options on an asset providing no income?
-
Determine the COP for a simple vapour compression refrigeration system.
-
Jim Olsen earns $800 per week for a five day week, and he is entitled to 12 paid holidays and four weeks of paid vacation. a. Over how many weeks should the holiday pay and vacation pay be expensed?...
-
An Analysis of the U.S. Supreme Court's Decision in Ricci v. DeStefano: The New Haven Firefighter's Case 1.Were there options available to officials in the City of New Haven in their attempt to...
-
Consider the calculation of the continuation value. Suppose Firm C has a WACC of 7%. Firm C's investment banker prepares a DCF valuation of Firm C using the WACC ap- proach. In her DCF valuation,...
-
You invested $1,000 through your broker three years ago. Your account balance at the beginning of each period is shown in the table below. Time Account balance Annual return 0 $1,000 n.a 1. $1,200 2....
-
Suppose you have a 4.50% coupon bond with a ytm of 2.0 percent and a term-to-maturity of 3 years.The bond pays its coupon ANNUALLY (once per year) and has a face value of $1,000. What is this bond's...
-
Identify a narrow policy issue of your choice in the Education sector of South Africa. 1. This policy should be attracting negative publicity from international or regional or national stakeholders...
-
A pint of beer costs GBP 4.54 in London, and the spot exchange rate is GBP 0.75 per USD. How many US dollars will it cost you to buy a pint of beer in London? Please round your answer to the nearest...
-
1. Consider the following 6 workers. Their names are in column (1) and their respective utility functions are in column (2). a. The table. I've filled out Adam's row for you. Fill out the rest of the...
-
Consider the following (X, Y) data: (53, 37), (34, 26), (10, 29), (63, 55), (28, 36). Find the regression equation
-
Vectors A and B as shown in the figure. Given their magnitude A=68m and B=27m and the angle 0=26. The resultant vector R is defined as the sum of A and B (R = A + B). Find x-component of resultant...
-
The company manufactures three products: wooden chairs, tables and dressers. AFC started off as a 'Mom & Pop' shop but has grown rapidly. AFC uses one assembly line to build all three products,...
-
Linda Kipp started a business on May 1, 20--. Analyze the following transactions for the first month of business using T accounts. Label each T account with the title of the account affected and then...
-
Page 205 shows a work sheet for Megaffin's Repairs. No additional investments were made by the owner during the month. REQUIRED 1. Prepare an income statement. 2. Prepare a statement of owner's...
-
Dr. John Salvaggi is a chiropractor. As of December 31, he owned the following property that related to his professional practice. Cash ................ $ 3,500 Office Equipment .......... 6,400...
-
Why are none of the bulbs in Figure 31. 24 lit? Data from Figure 31. 24 Figure 31.24 (1) (iii) NNN
-
In Figure 31. 25, identify the energy conversions that occur between points \(A\) and \(B, B\) and \(\mathrm{C}, \mathrm{C}\) and \(\mathrm{D}\), and \(\mathrm{D}\) and \(\mathrm{A}\). Data from...
-
In Figure 31. 26, bulb B is brighter than bulb C, which in turn is brighter than bulb A. Rank, largest first, \((a)\) the magnitudes of the potential differences across the bulbs, \((b)\) the...
Study smarter with the SolutionInn App