Question

In: Accounting

Quaint Stem Company is a high-end glassware manufacturer that produces fine stemware of the highest quality....

Quaint Stem Company is a high-end glassware manufacturer that produces fine stemware of the highest quality. The company is completing its fourth year of operations and is preparing to build its master budget for the coming year (2020). The budget will detail each quarter’s activity and the activity for the year in the total. The master budget will be based on the following information:

  1. Fourth-quarter sales for 2019 are 82,000 units and 65,000 for the first quarter of 2021.
  2. Unit sales by quarter (for 2020) are projected as follows:

First quarter                       66,000

Second quarter                  68,000

Third quarter                     75,000

Fourth quarter                   85,000

The selling price is $86 per unit. Cash sales make up 25% of all sales. Quaint collects 75 percent of the credit sales within the quarter in which they are realized; the other 25 percent are collected in the following quarter. There are no bad debts.

  1. The beginning inventory of finished goods is 13,000 units. Required ending inventory is 25% of the next quarter’s sales in units.
  2. Each stemware unit uses one and a half hours of direct labor and two units of direct materials. Laborers are paid $23.00 per hour, and one unit of direct materials costs $12.
  3. There are 10,400 units of direct materials in beginning inventory as of January 1, 2019. At the end of each quarter, Quaint plans to have 10 percent of the direct materials needed for next quarter’s unit sales. The ending unit of direct materials on hand at the end of the year was 19,500.
  4. Quaint buys direct materials on account. Half of the purchases are paid for in the quarter of acquisition, and the remaining half are paid for in the following quarter. Wages and salaries are paid on the 15th and 30th of each month.
  5. Fixed overhead totals $671,600 for each of the first three quarters. Of this total, $255,000 represents depreciation. During the fourth quarter, the depreciation and total fixed overhead increases by $18,575. All fixed expenses other than depreciation are paid for in cash in the quarter incurred. The fixed overhead rate is computed by dividing the year’s total fixed overhead by the year’s expected actual units produced.
  6. Variable overhead is budgeted at $5.50 per direct labor hour. All variable overhead expenses are paid for in the quarter incurred.
  7. Fixed selling and administrative expenses total $285,000 per quarter, including $50,000 depreciation.
  8. Variable selling and administrative expenses are budgeted at $6
  9. per unit sold. All selling and administrative expenses are paid for in the quarter incurred.
  10. The balance sheet as of December 31, 2019, is as follows:

ASSETS                                                                LIABILITIES and STOCKHOLDERS’EQUITY    

Cash                                              $      52,000     Accounts Payable                                $    680,000

Accounts Receivable                     1,275,000    

Raw Materials Inventory                   124,800

Finished Goods Inventory                 656,500     Capital Stock                                         9,750,000

Plant and equipment, net              9,360,000     Retained Earnings                                 1,038,300     Total Assets                                $11,468,300                Total Liab. & Equity              $11,468,300

  1. Quaint has a required cash balance of $50,000. An operating line of credit is available up to $250,000 at 8% interest. All borrowings and payments must be made in increments of $10,000 and interest is paid when principal is paid. All borrowings take place at the beginning of the quarter and all payments take place at the end of the quarter.
  2. Quaint will pay quarterly dividends of $55,000. At the end of the third quarter, $525,000 of equipment will be purchased and at the end of the fourth quarter, $225,000 of equipment will be purchased.
  3. The income tax rate is 30%.

Required

Prepare a master budget for Quaint Stem Company for each quarter of 2019 and for the year in total. The following component budgets must be included:

  1. Sales budget
  2. Production budget
  3. Direct materials purchases budget
  4. Direct labor budget
  5. Overhead budget
  6. Ending finished goods inventory budget
  7. Cost of goods sold budget
  8. Selling and administrative expenses budget
  9. Cash budget
  10. Pro forma income statement
  11. Pro forma balance sheet

Solutions

Expert Solution


Related Solutions

Johnson Fine Furniture produces elegant, high quality, hand-crafted wood furniture. The company is well known for...
Johnson Fine Furniture produces elegant, high quality, hand-crafted wood furniture. The company is well known for its superior craftsmanship. The company had the following results during its most recent fiscal year: Coffee Tables End Tables Lamps Totals Units             1,700             2,300             2,000            6,000 Sales Revenue $ 2,125,000 $ 2,070,000 $     280,000 $ 4,475,000 Variable Costs Materials & Labor    1,360,000      1,495,000         220,000 $ 3,075,000 Overhead         255,000         184,000           50,000 $     489,000 Contribution Margin $    ...
Frieda Falcon Fine Furniture produces elegant, high quality, hand-crafted wood furniture.  The company is well known for...
Frieda Falcon Fine Furniture produces elegant, high quality, hand-crafted wood furniture.  The company is well known for its superior craftsmanship.  The company had the following results during its most recent fiscal year: Coffee Tables End Tables Lamps Totals Units             1,700             2,300             2,000             6,000 Sales Revenue $  2,125,000 $  2,070,000 $     280,000 $  4,475,000 Variable Costs Materials & Labor      1,360,000      1,495,000         220,000 $  3,075,000 Overhead         255,000         184,000           50,000 $     489,000 Contribution Margin $     510,000 $     391,000 $       10,000 $     911,000 Fixed Costs    Allocated GS&A         103,700         140,300         122,000 $     366,000    Marketing & Engineering           68,000           46,000...
Company A manufactures a line of high-end exercise equipment of commercial quality. Assume that the Controller...
Company A manufactures a line of high-end exercise equipment of commercial quality. Assume that the Controller has proposed changing from a traditional costing system to an activity-based costing system. The Vice-President Finance is not convinced, so she requests that the next large order for equipment be costed under both systems to compare and analyze. The company receives an order from Slim Inc, for 150 low impact treadmills, which the Controller identifies as the order to use for dual costing. The...
Sunland Company produces high-quality microscopes for education and health care uses. The company uses a job...
Sunland Company produces high-quality microscopes for education and health care uses. The company uses a job order costing system. Because the microscopes’ optics require significant manual labor to ensure adherence to strict manufacturing specifications, the company applies overhead on the basis of direct labor hours. At the beginning of 2017, the company estimated its manufacturing overhead would be $1,960,000 and that employees would work a total of 98,000 direct labor hours. During March, the company worked on the following five...
Felix's Fine Jewelry produces fine jewelry for department stores. The following costs incurred by the company...
Felix's Fine Jewelry produces fine jewelry for department stores. The following costs incurred by the company may be classified as direct materials, direct labor, manufacturing overhead, or period costs. Classify the costs and total by classification. Prepare an operating income statement which shows the deductions of expense in terms of total classification by category: direct materials, direct labor, manufacturing overhead, or period costs. Assume Felix's Fine Jewelry's revenue for the period was $8,000,000, and there is no change in ending...
Sportway Inc. produces high-quality tennis racquets and golf clubs using a patented forming process and high-quality...
Sportway Inc. produces high-quality tennis racquets and golf clubs using a patented forming process and high-quality hand-finishing. Products move through two production departments: Forming and Finishing. The company uses departmental overhead rates to allocate overhead costs. Overhead is allocated based on machine-hours in Forming and direct labour cost in Finishing. Information related to estimated volumes and denominator values for the coming year are provided below: Tennis Racquets Golf Clubs   Annual production and sales 5,200 8,300   Direct materials per unit $...
Fancy furniture LTD is a company that produces high-quality custom furniture for commercial and residential customers....
Fancy furniture LTD is a company that produces high-quality custom furniture for commercial and residential customers. You have been asked to calculated the WACC for this company and are given the following information; Fancy furniture ltd is a publicly listed company and it currently has 20 million ordinary shares on issue. The beta of its share is 1.7 FF is forecasting to pay a dividend of $0.8 in the coming year and the dividend is expected to grow at a...
Company ehf. which produces high quality headphones has been in the marketing campaign for the past...
Company ehf. which produces high quality headphones has been in the marketing campaign for the past six years. To meet ever-increasing competition in this market, the CEO of Company ehf. that an ad campaign is needed next year to maintain the company's market share. At his request, the operating accountant has compiled the accompanying figures from the cost accounting for 2012 in order to prepare the marketing plan for next year, ie. 2013. It is requested: a) What will be...
Pinder Co. produces and sells high-quality video equipment.
Present value of bonds payable; discountPinder Co. produces and sells high-quality video equipment. To finance its operations, Pinder issued $26,000,000 of three-year, 8% bonds, with interest payable semiannually, at a market (effective) interest rate of 10%.Determine the present value of the bonds payable. Round your answer to the nearest dollar.$ _____________
Bern Fly Rod Company is a small manufacturer of high quality graphite fly-fishing rods. It sells...
Bern Fly Rod Company is a small manufacturer of high quality graphite fly-fishing rods. It sells its products to fly-fishing shops throughout the United States and Canada. Bern began as a small company with four salespeople, all family members of the owner. Because of the high popularity and recent growth of fly-fishing, Bern now employs a seasonal, nonfamily, sales force of 16. The salespeople travel around the country giving flycasting demonstrations of their new models to fly-fishing shops. When the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT