Question

Problem #1 Tandy, Inc. is in the business of manufacturing men’s and women’s leather computer bags.  On...

Problem #1

Tandy, Inc. is in the business of manufacturing men’s and women’s leather computer bags.  On January 1, 2019 they started their new fiscal year.  The following is their trial balance as of December 31, 2018:

            Account                                               Dr                                Cr

            Cash                                                     $   43,200

            Accounts Receivable                            $     9,000

            Raw Materials Inventory (1)                  $    20,240

            Work in Process Inv. (2)                         $            0

            Finished Goods Inv. (3)                          $     8,100

            Land                                                     $ 225,000

            Equipment                                           $ 310,000

            Vehicles                                               $   84,200

            Accumulated Depreciation                                                       $     55,100

            Long-term Investments                        $   78,500

            Accounts Payable                                                                     $     14,700

            Wages Payable                                                                         $       8,470

            Mortgage Payable (4)                                                                $  214,500

            Common Stock (5)                                                                    $    25,000

            APIC                                                                                         $  125,000

            Retained Earnings                                                                     $   335,470

                        Totals                                       $    778,240                  $   778,240

Includes 2,860 feet of leather at $4 per foot, 5,000 feet of nylon lining at $1.25 per foot, and 510 golden buckles at $5 per buckle

No bags are currently in process at the beginning of January

Includes 150 completed bags (manufacturing overhead has been applied)

Monthly payments (interest and principle) are $ 2,500

$0.10 par value, 300,000 share authorized and 250,000 share outstanding

For the coming year, you have been put in charge of creating the operational budget schedules and the cash budget.  Below is information for the first three months of the fiscal year.

Sales Forecasts

For this coming year, you have raised your sales price to $155 per bag.  Based on sales contracts you have signed with your major corporate customers, you anticipate the following sales for the first three months of 2019:

            January            235 bags

            February          220 bags

            March              190 bags

According to the terms of the sales contracts you require each customer to pay 80% of the sales price in the month of sale and 18% in the month following.  In December 2018, Tandy had $30,000 in total sales.

The production process

Each bag produced requires 4 feet of leather, 9 feet of nylon, 3 gold buckles, and 3.5 hours of direct labor.  Currently you are paying your assembly workers $17 / hour. In order to meet the following month’s demand, Tandy desires to keep 15% of the next month’s sales in Finished Goods Inventory.  Tandy is forecasting sales in April, 2019 of 285 bags.  Additionally, they also keep 30% of next month’s production needs in raw materials inventory.  Tandy anticipates production of 255 units in April, 2019.  Tandy has signed contracts with their suppliers to purchase leather at $4 a foot and buckles at $5 per buckle for the following year.  Their policy is to pay for 75% of raw materials at the time of purchase and the remaining 25% in the following month.  

Required

Please prepare the sales and production budgets for January – March of 2019.

Homework Answers

Answer #1

Solution:

Sales Budget - Tandy Inc.
Particulars January February March Total
Budgeted sales units (Bags) 235 220 190 645
Selling price per unit $155.00 $155.00 $155.00 $155.00
Budgeted sales $36,425.00 $34,100.00 $29,450.00 $99,975.00
Production Budget - Tandy Inc.
Particulars January February March Total
Budgeted sales units (Bags) 235 220 190 645
Desired ending inventory (15% of next month sales) 33 29 43 43
Beginning inventory 150 33 29 150
Budgeted production units 118 216 204 538
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Problem #1 Tandy, Inc. is in the business of manufacturing men’s and women’s leather computer bags.  On...
Problem #1 Tandy, Inc. is in the business of manufacturing men’s and women’s leather computer bags.  On January 1, 2019 they started their new fiscal year.  The following is their trial balance as of December 31, 2018:             Account                                               Dr                                Cr             Cash                                                     $   43,200             Accounts Receivable                            $     9,000             Raw Materials Inventory (1)                  $    20,240             Work in Process Inv. (2)                         $            0             Finished Goods Inv. (3)                          $     8,100             Land                                                     $ 225,000             Equipment                                           $ 310,000             Vehicles                                               $   84,200             Accumulated Depreciation                                                       $     55,100             Long-term Investments                        $   78,500             Accounts Payable                                                                     $     14,700             Wages Payable                                                                         $       8,470             Mortgage Payable (4)                                                                $  214,500             Common Stock (5)                                                                    $    25,000             APIC                                                                                         $  125,000             Retained Earnings                                                                     $   335,470                         Totals                                       $    778,240                  $   778,240 Includes 2,860 feet of leather...
Tandy, Inc. is in the business of manufacturing men’s and women’s leather computer bags. On January...
Tandy, Inc. is in the business of manufacturing men’s and women’s leather computer bags. On January 1, 2019 they started their new fiscal year. The following is their trial balance as of December 31, 2018:             Account                                               Dr                                Cr             Cash                                                     $   43,200             Accounts Receivable                            $     9,000             Raw Materials Inventory (1)                  $    20,240             Work in Process Inv. (2)                         $            0             Finished Goods Inv. (3)                          $     8,100             Land                                                     $ 225,000             Equipment                                           $ 310,000             Vehicles                                              ...
Tandy, Inc. is in the business of manufacturing men’s and women’s leather computer bags. On January...
Tandy, Inc. is in the business of manufacturing men’s and women’s leather computer bags. On January 1, 2019 they started their new fiscal year. The following is their trial balance as of December 31, 2018:             Account                                               Dr                                Cr             Cash                                                     $   43,200             Accounts Receivable                            $     9,000             Raw Materials Inventory (1)                  $    20,240             Work in Process Inv. (2)                         $            0             Finished Goods Inv. (3)                          $     4,500             Land                                                     $ 225,000             Equipment                                           $ 310,000             Vehicles                                              ...
Setting Standards, Calculating and Using Variances Leather Works is a family-owned maker of leather travel bags...
Setting Standards, Calculating and Using Variances Leather Works is a family-owned maker of leather travel bags and briefcases located in the northeastern part of the United States. Foreign competition has forced its owner, Heather Gray, to explore new ways to meet the competition. One of her cousins, Wallace Hayes, who recently graduated from college with a major in accounting, told her about the use of cost variance analysis to learn about efficiencies of production. In May of last year, Heather...
EcoSacks manufactures cloth shopping bags. The controller is preparing a budget for the coming year and...
EcoSacks manufactures cloth shopping bags. The controller is preparing a budget for the coming year and asks for your assistance. The following costs and other data apply to bag production. Direct materials per bag 1.70 yard cotton at $4.70 per yard 0.90 yards canvas finish at $12.70 per yard Direct labor per bag 1.20 hour at $18.70 per hour Overhead per bag Indirect labor $ 1.30 Indirect materials 0.90 Power 1.10 Equipment costs 2.00 Building occupancy 1.60 Total overhead per...
Problem 8-30 Integration of the Sales, Production, and Direct Materials Budgets [LO8-2, LO8-3, LO8-4] Milo Company...
Problem 8-30 Integration of the Sales, Production, and Direct Materials Budgets [LO8-2, LO8-3, LO8-4] Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: a. The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 38,000 October 28,000 August 86,000 September 55,000 November 14,500 December 15,000 The selling price of the beach umbrellas is $13 per...
Iguana, Inc., manufactures bamboo picture frames that sell for $30 each. Each frame requires 4 linear...
Iguana, Inc., manufactures bamboo picture frames that sell for $30 each. Each frame requires 4 linear feet of bamboo, which costs $3.00 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $15 per hour. Iguana has the following inventory policies: Ending finished goods inventory should be 40 percent of next month’s sales. Ending raw materials inventory should be 30 percent of next month’s production. Expected unit sales (frames) for the upcoming months follow: March...
Exercise 8-16 (Algo) Direct Materials and Direct Labor Budgets [LO8-4, LO8-5] The production department of Zan...
Exercise 8-16 (Algo) Direct Materials and Direct Labor Budgets [LO8-4, LO8-5] The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 9,000 12,000 11,000 10,000 In addition, 15,750 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is $5,600. Each...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash $ 80,000 Accounts receivable 487,500 Raw materials inventory 93,390 Finished goods inventory 438,000 Total current assets 1,098,890 Equipment, gross 640,000 Accumulated depreciation (170,000 ) Equipment, net 470,000 Total assets $ 1,568,890 Liabilities and Equity Accounts payable $ 215,690 Short-term notes payable 32,000 Total current liabilities 247,690 Long-term note payable 520,000 Total liabilities 767,690 Common stock 355,000...
To prepare a master budget for April, May, and June of 2019, management gathers the following...
To prepare a master budget for April, May, and June of 2019, management gathers the following information. ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash $ 54,000 Accounts receivable 354,375 Raw materials inventory 100,495 Finished goods inventory 333,000 Total current assets 841,870 Equipment 628,000 Accumulated depreciation (164,000 ) Equipment, net 464,000 Total assets $ 1,305,870 Liabilities and Equity Accounts payable $ 212,195 Short-term notes payable 26,000 Total current liabilities 238,195 Long-term note payable 514,000 Total liabilities 752,195 Common...