You have been given the following information to prepare the budgets for all 4 Quarters, 2018...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You have been given the following information to prepare the budgets for all 4 Quarters, 2018 for the Bullwinkle, Inc. The product is kayaks. The company is preparing the budget for budget analysis for 2018. Requirements: Prepare the following budgets for 4 Quarters, 2018: 1) 2) 3) 4) Sales budget Production budget Materials budget Labor budget Manufacturing Overhead budget Selling and Administrative budget Expected collections 5) 6) 7) 8) 9) Expected payments Cash budget Discuss why the company should prepare flexible budgets rather than static budgets Discuss the importance of a responsibility report. 11) Sales isce 250 35o 1,100 rue Expected units sales for quarter ending 03-31-2018 Expected units sales for quarter ending 06-30-2018 Expected units sales for quarter ending 09-30-2018 1,000 units 1,500 units 750 units Expected units sales for quarter ending 12-31-2018 Expected unit sales for quarter ending 03-31-2019 Expected units sales for quarter ending 06-30-2019 750 units -1,100 units -1,500 units Unit sales price $ 275.00 Sales are on account with 85% of the accounts receivable collected in the quarter of sale, and 15% are collected in the quarter after sale. Accounts Receivable on December 31, 2017 totaled $194,750.00 collected in the 1st Qtr, 2018. 50% of materials are paid in the quarter of purchase, and 50% are paid in the quarter after purchase. Accounts Payable on December 31, 2017 totaled $120,595.00, paid 100% in 1st Qtr, 2018. $ 145,000.00 Sales of Common Stock 1st Qtr, 2018: Sale of Preferred Stock 2nd Qtr, 2018: $ 294,650.00 3rd Qtr, 2018 $ 310,500.00 The company policy is to have finished goods ending inventory in a quarter equal to 20% of the next quarter's expected sales. Ending finished goods inventory at December 31, 2017 will be 200 kayaks. Production of each kayak requires 20 pounds of polyethylene powder and a finishing kit (rope, seat, hardware, etc.). The ending inventory of pewder should be 25% of the amount needed for production in the next quarter. Assume that the ending inventory of powder on December 31, 2017 is 19,400 pounds. The finishing kits can be assembled as they are needed. The powder used in the kayaks costs $1.50 per pound, and the finishing kits cost $5.00 each. Production of a single kayak requires 2 hours of time by more experienced, typel employees, and 3 hours of finishing time by type Il employees. The type l employees are paid $15 per hour, and the type Il employees are paid $12 per hour. > Dor ta bah Manufacturing Overhead information: Indirect Materials 0.30 Per DL hour for Skilled employees Indirect Labor 0.50 Per DL hour for Skilled employees Utilities 0.45 Per DL hour for Skilled empioyees Maintenance 0.25 Per DL hour for Skilled employees $ 8,500.00 Per month $ 3,900.00 Per month Salaries Depreciation You do not need to classify manufacturing overhead costs by variable and fixed. Information for the Selling and Administrative Budget: $ 3,475.00 per month $ 1,500.00 per month $ 10,800.00 per month $ 2,500.00 per month $ 3,500.00 per month Advertising Insurance Salaries Depreciation Other fixed costs You do not need to classify selling and administrative costs by variable and fixed. The cash balance on December 31, 2017 totaled $100,500. Management has decided to maintain a cash balance of at least $200,000 at the end of each quarter, 2018. Dividends are paid each quarter at the rate of $2.50 per share for 5,000 shares outstanding. The company has an open line of credit (LOC) with the bank. The terms of agreement requires borrowing to be in $1,000 increments at 8% interest. The funds borrowed, if necessary, at the end of each quarter are paid back the following quarter. A $475,000.00 equipment purchase is planned for the 2nd quarter, 2018, and a $370,000.00 equipment purchase is planned for the 3rd quarter, 2018. You have been given the following information to prepare the budgets for all 4 Quarters, 2018 for the Bullwinkle, Inc. The product is kayaks. The company is preparing the budget for budget analysis for 2018. Requirements: Prepare the following budgets for 4 Quarters, 2018: 1) 2) 3) 4) Sales budget Production budget Materials budget Labor budget Manufacturing Overhead budget Selling and Administrative budget Expected collections 5) 6) 7) 8) 9) Expected payments Cash budget Discuss why the company should prepare flexible budgets rather than static budgets Discuss the importance of a responsibility report. 11) Sales isce 250 35o 1,100 rue Expected units sales for quarter ending 03-31-2018 Expected units sales for quarter ending 06-30-2018 Expected units sales for quarter ending 09-30-2018 1,000 units 1,500 units 750 units Expected units sales for quarter ending 12-31-2018 Expected unit sales for quarter ending 03-31-2019 Expected units sales for quarter ending 06-30-2019 750 units -1,100 units -1,500 units Unit sales price $ 275.00 Sales are on account with 85% of the accounts receivable collected in the quarter of sale, and 15% are collected in the quarter after sale. Accounts Receivable on December 31, 2017 totaled $194,750.00 collected in the 1st Qtr, 2018. 50% of materials are paid in the quarter of purchase, and 50% are paid in the quarter after purchase. Accounts Payable on December 31, 2017 totaled $120,595.00, paid 100% in 1st Qtr, 2018. $ 145,000.00 Sales of Common Stock 1st Qtr, 2018: Sale of Preferred Stock 2nd Qtr, 2018: $ 294,650.00 3rd Qtr, 2018 $ 310,500.00 The company policy is to have finished goods ending inventory in a quarter equal to 20% of the next quarter's expected sales. Ending finished goods inventory at December 31, 2017 will be 200 kayaks. Production of each kayak requires 20 pounds of polyethylene powder and a finishing kit (rope, seat, hardware, etc.). The ending inventory of pewder should be 25% of the amount needed for production in the next quarter. Assume that the ending inventory of powder on December 31, 2017 is 19,400 pounds. The finishing kits can be assembled as they are needed. The powder used in the kayaks costs $1.50 per pound, and the finishing kits cost $5.00 each. Production of a single kayak requires 2 hours of time by more experienced, typel employees, and 3 hours of finishing time by type Il employees. The type l employees are paid $15 per hour, and the type Il employees are paid $12 per hour. > Dor ta bah Manufacturing Overhead information: Indirect Materials 0.30 Per DL hour for Skilled employees Indirect Labor 0.50 Per DL hour for Skilled employees Utilities 0.45 Per DL hour for Skilled empioyees Maintenance 0.25 Per DL hour for Skilled employees $ 8,500.00 Per month $ 3,900.00 Per month Salaries Depreciation You do not need to classify manufacturing overhead costs by variable and fixed. Information for the Selling and Administrative Budget: $ 3,475.00 per month $ 1,500.00 per month $ 10,800.00 per month $ 2,500.00 per month $ 3,500.00 per month Advertising Insurance Salaries Depreciation Other fixed costs You do not need to classify selling and administrative costs by variable and fixed. The cash balance on December 31, 2017 totaled $100,500. Management has decided to maintain a cash balance of at least $200,000 at the end of each quarter, 2018. Dividends are paid each quarter at the rate of $2.50 per share for 5,000 shares outstanding. The company has an open line of credit (LOC) with the bank. The terms of agreement requires borrowing to be in $1,000 increments at 8% interest. The funds borrowed, if necessary, at the end of each quarter are paid back the following quarter. A $475,000.00 equipment purchase is planned for the 2nd quarter, 2018, and a $370,000.00 equipment purchase is planned for the 3rd quarter, 2018.
Expert Answer:
Answer rating: 100% (QA)
7 Expected collection for 2018 Particulars Amount in Collections in first quarter of 2018 Amount collected from the last quarter of 2017 Collection fr... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
You have been given the following information for RPE Consulting for the year ended July 31, 2014. Required 1. Prepare the company's income statement, statement of changes in equity, and balance...
-
You have been given the following information about ALG Co. Ltd., which uses a standard cost system in accounting for its one product: 1. In the month of November 2016, 5,000 units were produced. 2....
-
You have been given the following information about ALG Co. Ltd., which uses a standard cost system in accounting for its one product: 1. In the month of November 2012, 5,000 units were produced. 2....
-
What is performance measurement?
-
The research department at the home office of New Hampshire Insurance conducts on-going research on the causes of automobile accidents, the characteristics of the drivers, and so on. A random sample...
-
Delph Manufacturing Company is going to purchase an auto parts component from one of two competing suppliers. Delph is going to base its decision, in part, on the supply chain performance of the two...
-
The Sky Company's income statement and comparative balance sheets as of December 31 of 2019 and 2018 follow: During the year, the following transactions occurred: 1. Sold long-term investments...
-
Anew Italian restaurant called the Olive Grove is opening in several locations in the Memphis area. The marketing manager for these stores has a budget of $150,000 to use in advertising and...
-
Develop an interview questionnaire for you to conduct interviews for potential candidates for the job of store manager ,cashier, sales associate, and inventory control specialist in clothing company...
-
1. We need a corporate goal for SCR that refers to our new training activity. Prepare a draft to show Jesse. 2. Jesse wants my opinion on whether or not SCR needs a system review committee. Need to...
-
A mixture sample containing 80% NaHCO 3 and 20% NaCl was marketed for certain food preparations. As an analytical chemist, you took a 2.00 g of the mixture and heated it until the decomposition...
-
The manager of a restaurant walks around and asks selected customers about the service they have received. Which type of sample does this represent?
-
A _______ is a subset of a population. In Exercises 712, fill in each blank with the appropriate word or phrase.
-
Large samples usually give reasonably accurate results, no matter how they are drawn. In Exercises 68, determine whether the statement is true or false. If the statement is false, rewrite it as a...
-
True or false: An experiment where neither the investigators nor the subjects know who has been assigned to which treatment is called a double-blind experiment.
-
A researcher selects 4 of 12 high schools in a certain region and surveys all of the administrative staff members in each school about a potential change in the ordering of supplies. Which type of...
-
describe what is the different between Backbone Fast vs. Uplink Fast. keep the dots point thanks
-
Smthe Co. makes furniture. The following data are taken from its production plans for the year. Required: 1. Determine the hazardous waste disposal cost per unit for chairs and for tables if costs...
-
As the result of stockholder pressure, RJR Nabisco is considering spinning off its food division. You have been asked to estimate the beta for the division and decide to do so by obtaining the beta...
-
Answer true or false to the following statements: a. The return on equity for a project will always be higher than the return on capital on the same project. b. If the return on capital is less than...
-
Every investor in the capital asset pricing model owns a combination of the market portfolio and a riskless asset. Assume that the standard deviation of the market portfolio is 30% and that the...
-
What is allocative efficiency?
-
Describe and explain the concept of diminishing marginal product.
-
Which of the following is true? a. In constant-cost industries, the cost curves of the firm are not affected by changes in the output of the entire industry. b. In an increasing-cost industry, the...
Study smarter with the SolutionInn App