2.99 See Answer

Question: Inwood Gifts Corporation begins business today,


Inwood Gifts Corporation begins business today, December 31, Year 1. Rebecca Ortiz, the president, is trying to prepare the company’s master budget for the first three months (January, February, and March) of Year 2. Since you are her good friend and an accounting student, Ms. Ortiz asks you to prepare the budget based on the following specifications.
Required
1. January sales are estimated to be $500,000, of which 30 percent will be cash and 70 percent will be credit. The company expects sales to increase at the rate of 10 percent per month. Prepare a sales budget.
2. The company expects to collect 100 percent of the accounts receivable generated by credit sales in the month following the sale. Prepare a schedule of cash receipts.
3. The cost of goods sold is 50 percent of sales. The company desires to maintain a minimum ending inventory equal to 20 percent of the next month’s cost of goods sold. The ending inventory of March is expected to be $66,000. Assume that all purchases are made on account. Prepare an inventory purchases budget.
4. The company pays 60 percent of accounts payable in the month of purchase and the remaining 40 percent in the following month. Prepare a cash payments budget for inventory purchases.
5. Budgeted selling and administrative expenses per month follow:
Salary expense (fixed) $50,000
Sales commissions 8% of sales
Supplies expense 4% of sales
Utilities (fixed) $3,600
Depreciation on store fixtures (fixed) $10,000
Rent (fixed) $14,400
Miscellaneous (fixed) $4,000
*The capital expenditures budget indicates that Inwood will spend $700,000 on January 1 for store fixtures. The fixtures are expected to have a $100,000 salvage value and a five-year (60-month) useful life.
Use this information to prepare a selling and administrative expenses budget.
6. Utilities and sales commissions are paid the month after they are incurred; all other expenses are paid in the month in which they are incurred. Prepare a cash payments budget for selling and administrative expenses.
7. The company borrows funds, in increments of $1,000, and repays them in any amount available on the last day of the month. It pays interest of 1.5 percent per month in cash on the last day of the month. For safety, the company desires to maintain a $100,000 cash balance. The company pays its vendors on the last day of the month. Prepare a cash budget.
8. Prepare a pro forma income statement for the quarter.
9. Prepare a pro forma balance sheet at the end of the quarter.
10. Prepare a pro forma statement of cash flows for the quarter.



> Grenora Company’s beginning work in process inventory consisted of 7,500 units of product on January 1, Year 2. During Year 2, the company started 32,500 units of product and transferred 34,000 units to finished goods inventory. The ending work in proces

> At the beginning of Year 3, Elgin Company had 5,000 units of product in its work in process inventory, and it started 25,000 additional units of product during the year. At the end of the year, 6,000 units of product were in the work in process inventory

> Fullerton Paper Products Corporation produces paper cups using two production departments, printing and forming. Beginning balances and printing department data for Year 2 follow. 1. Fullerton Paper Products issued additional common stock for $180,000 ca

> Letcher Corporation makes blue jeans. Its process involves two departments, cutting and sewing. The following data pertain to the cutting department’s transactions in Year 2. 1. The beginning balance in work in process inventory was $30,000. This invento

> Use the ending balances from Problem 12-15B as the beginning balances for this problem. The transactions for the second year of operation (Year 2) are described here. (Assume that all transactions are cash transactions unless otherwise indicated.) 1. The

> Dawson Food Company makes frozen vegetables. Production involves two departments, processing and packaging. Raw materials are cleaned and cut in the processing department and then transferred to the packaging department where they are packaged and frozen

> Prairie Roofing Corporation was founded on January 1, Year 1, when stockholders contributed $12,000 for common stock. During the year, Prairie purchased $6,400 of direct raw materials and used $5,520 of direct materials. There were 80 hours of direct lab

> Custom Automobile Restoration Shop (CARS) is a small shop dedicated to high-quality restora­tions of vintage cars. Although it will restore an automobile that a customer already owns, usually the shop buys an old vehicle, restores it, and then

> Preston Corporation was created on January 1, Year 1, when it received a stockholder’s contribution of $92,000. It purchased $21,000 of raw materials and worked on three job orders during the year. Data about these jobs follow. (Assume

> Darwin Manufacturing pays its production managers a bonus based on the company’s profitability. During the two most recent years, the company maintained the same cost structure to manufacture its products. Darwin’s sal

> Covington Company makes leather chairs that it sells for $500 per chair. Each chair requires $72 of direct materials and $170 of direct labor. Fixed overhead costs are expected to be $300,000 per year. Covington expects to sell 1,500 chairs during the co

> Sardina Manufacturing Company makes a product that sells for $30 per unit. Manufacturing costs for the product amount to $16 per unit variable, and $96,000 fixed. During the current accounting period, Sardina made 8,000 units of the product and sold 7,60

> Linda Wheeler has worked as the plant manager of Vicksburg Corporation, a large manufacturing company, for 10 years. The company produces stereo DVD players for automotive vehicles and sells them to some of the largest car manufacturers in the country. M

> The following events apply to Andover Manufacturing Company. Assume that all transactions are cash transactions unless otherwise indicated. Transactions for the Year 1 Accounting Period 1. The company was started on January 1, Year 1, when it acquired $4

> Blanchard Manufacturing Company manufactures puzzles that depict the works of famous artists. The company rents a small factory and uses local labor on a part-time basis. The following accounting events affected Blanchard during its first year of operati

> Meadowbrook Manufacturing started Year 2 with the following account balances. Cash $7,000 Common stock 5,600 Retained earnings 2,800 Raw materials inventory 600 Work in process inventory 440 Finished goods inventory (50 units @ $7.20/unit) 360 Transact

> The following Balance Sheet was taken from the records of Ansgar Manufacturing Company at the beginning of Year 2. Transactions for the Accounting Period 1. Ansgar purchased $2,600 of direct raw materials and $300 of indirect raw materials on account. Th

> The following accounting events affected Carmel Manufacturing Company during its first three years of operation. Assume that all transactions are cash transactions. Transactions for Year 1 Started manufacturing company by issuing common stock for $1,000.

> Stanley Manufacturing Company, which sold 16,000 units of product at $20 per unit, collected the following information regarding three different levels of production. Required 1. Construct a spreadsheet that includes the preceding data in the top of the

> Mansell Corporation faces stiff market competition. Top management is considering the replacement of its current production facility. The board of directors requires all capital investments to meet or exceed a 9 percent rate of return. However, the board

> Laurel Steel Company decided to spend $160,000 to purchase new state-of-the-art equipment for its manufacturing plant. The equipment has a five-year useful life and a salvage value of $40,000. It is expected to generate additional cash revenue of $64,000

> Wonda Munro just won a lottery and received a cash award of $450,000 net of tax. She is 61 years old and would like to retire in four years. Weighing this important fact, she has found two possible investments, both of which require an immediate cash pay

> Pratt and Sullivan Services is planning a new business venture. With $125,000 of available funds to invest, it is investigating two options. One is to acquire an exclusive contract to operate vending machines in civic and recreation centers in a small su

> Dale Thomas's rich uncle gave him $100,000 cash as a gift for his 40th birthday. Unlike his spoiled cousins who spend money carelessly, Mr. Thomas wants to invest the money for his future retirement. After an extensive search, he is considering one of tw

> Shawn Guzman is wondering whether he made the right decision four years ago. As the president of Guzman Health Care Services, he acquired a hospital specializing in elder care with an initial cash investment of $1,400,000. Mr. Guzman would like to know w

> Craig Pike, the president of Craig’s Moving Services Inc., is planning to spend $800,000 for new trucks. He expects the trucks to increase the company’s cash inflow as follows. Note that annual cash inflows below are

> Perry Automobile Repair Inc. currently has three repair shops in Boston. Jerry Perry, the president and chief executive officer, is facing a pleasant dilemma: the business has continued to grow rapidly and major shareholders are arguing about different w

> Gardner Electronics Corporation makes a Wi-Fi receiver that it sells to retail stores for $75 each. The variable cost to produce a receiver is $35 each; the total fixed cost is $5,000,000. Gardner is operating at 80 percent of capacity and is producing 2

> Beaumont Trading Company (BTC) has three divisions. BTC has a desired rate of return of 6.0 percent. The operating assets and income for each division are as follows. BTC headquarters has $250,000 of additional cash to invest in one of its divisions. The

> Manning Cassey Computers (MCC) plans to produce and sell 1,600 computers for $720 each in the next fiscal year. The company’s cost data follow. Components from wholesaler $480 per computer Assembly labor $15 per hour Manufacturing space rent $3,000 per

> Roswell Company has operating assets of $8,000,000. The company’s operating income for the most recent accounting period was $600,000. The Lawrence Division of Roswell controls $1,600,000 of the company’s assets and earned $144,000 of its operating incom

> Gwinnett Corporation operates three investment centers. The following financial statements apply to the investment center named Rite Division. Required 1. Should operating income or net income be used to determine the rate of return (ROI) for the Rite in

> Bonner Corporation’s balance sheet indicates that the company has $320,000 invested in operating assets. During Year 3, Bonner earned $24,000 of operating income on $480,000 of sales. Required 1. Compute Bonner’s operating profit margin percentage for Ye

> Sheridan Industries Inc. has five different divisions; each is responsible for producing and marketing a particular product line. The electronics division makes cellular telephones, pagers, and modems. The division also buys and sells other electronic pr

> The mortgage division of Magee Financial Services Inc. is managed by a vice president who supervises three regional operations. Each regional operation has a general manager and several branches directed by branch managers. The West region has two branch

> Chad Bentley, president of Sabrin Corporation, evaluated the performance report of the company’s production department. Mr. Bentley was confused by some arguments presented by Jeannette Dolan, the production manager. Some relevant data

> At a professional conference just a few days ago, Carlos Santiago, the president of Ocala Corporation, learned how the concept of controllability relates to performance evaluation. In preparing to put this new knowledge into practice, he reviewed the fin

> A fire destroyed most of Ordessa Products Corporation’s records. Megan Carey, the company’s accountant, is trying to piece together the company’s operating results from salvaged documents. She discovered the following data. Standard materials quantity pe

> Gould Manufacturing Company, which makes aluminum alloy wheels for automobiles, recently introduced a new luxury wheel that fits small sports cars. The company developed the following standards for its new product. Amount of direct materials per wheel 2

> Shaffer Corporation makes mouse pads for computer users. After the first year of operation, Peggy Shaffer, the president and chief executive officer, was eager to determine the efficiency of the company’s operation. In her analysis, she used the followin

> Cliff Dennis may become a rich man. He is the creative force behind Amazing Drives, a new company. Amazing makes external drives that permit computer users to store large amounts of information on thumb drives. Amazing has experienced tremendous growth s

> Watonga Swimsuit makes swimsuits. In Year 2, Watonga produced its most popular swimsuit, the Sarong, for a standard labor price of $33.60 per hour. The standard amount of labor was 1.0 hour per swimsuit. The company had planned to produce 100,000 Sarong

> Watonga Swimsuit Specialties Inc. makes fashionable women’s swimsuits. Its most popular swimsuit, with the Sarong trade name, uses a standard fabric amount of six yards of raw material with a standard price of $9 per yard. The company planned to produce

> Martin Hickey was a new cost accountant at Freeport Plastics Corporation. He was assigned to analyze the following data that his predecessor left him. Planned volume for year (static budget) 10,000 units Standard direct materials cost per unit 2 pounds @

> Newkirk Sporting Goods Co. manufactures baseballs. According to Newkirk’s Year 3 budget, the company planned to incur $180,000 of fixed manufacturing overhead costs to make 200,000 baseballs. Newkirk actually produced 187,000 balls, incurring $177,600 of

> Use the standard price and cost data supplied in Problem 8-20B. Assume that Ponca actually produced and sold 432,000 units. The actual sales price and costs incurred follow. Required 1. Determine the flexible budget variances. 2. Indicate whether each v

> Ponca Food Corporation developed the following standard price and costs for a refrigerated TV dinner that the company produces. Standard price and variable costs per unit Sales price $5.40 Materials cost 1.60 Labor cost 0.60 Overhead cost 0.12 Selling, g

> The Marketing Department of Barlett State University planned to hold its annual distinguished visiting lecturer (DVL) presentation in October Year 4. The head of the department prepared the following budget based on costs that had been incurred in the pa

> Executive officers of Freedonia Seafood Processing Company are holding a planning session for fiscal Year 3. They have already established the following standard price and costs for their canned seafood product. Standard price and variable costs Price pe

> Myrtle Enterprises Inc. has two products, palm-size computers and programmable calculators. Tammy Dwyer, the chief executive officer, is working with her staff to prepare next year’s budget. Ms. Dwyer estimates that sales will increase

> Barret Cameron, a student in Professor Wagner’s managerial accounting course, asked the following question: “In the first accounting course, the teacher said inventory costs flow on a FIFO, LIFO, or weighted average pattern. Now you are telling us invent

> Shane Corbett, a successful entrepreneur, is reviewing the results of his first year in business. His accountant delivered the following income statement just five minutes ago. Mr. Corbett would like net income to increase 20 percent in the next year. Th

> Chang Company has budgeted the following cash flows. Chang had an $18,000 cash balance on April 1. The company desires a $30,000 cash balance before paying interest. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of

> Javior’s Travel Services has prepared its selling and administrative expenses budget for the next quarter. It pays all expenses when they are incurred except sales commissions, advertising expense, and telephone expense. These three ite

> Mankota Company’s purchasing manager, Fernando Garza, is preparing a purchases budget for the next quarter. At his request, Ruben Carpenter, the manager of the sales department, forwarded him the following preliminary sales budget. For

> Estlin Corporation sells mail-order computers. In December Year 2, it has generated $300,000 of sales revenue; the company expects a 20 percent increase in sales in January and 10 percent in February. All sales are on account. Estlin normally collects 80

> Melissa Putnam, the director of Kelso Corporation’s Mail-Order Division, is preparing the division’s budget proposal for next year. The company’s president will review the proposal for approval. Ms. P

> Ewing Company makes two products, M and N. Product information follows. Required Identify the product that should be produced or sold under each of the following constraints. Consider each constraint separately. 1. One unit of Product M requires three ho

> Liao Construction Components Inc. purchased a machine on January 1, Year 1, for $480,000. The chief engineer estimated the machine’s useful life to be six years and its salvage value to be zero. The operating cost of this machine is $240,000 per year. By

> Rooney Company’s electronics division produces a DVD player. The vice president in charge of the division is evaluating the income statement showing annual revenues and expenses associated with the division’s operating

> Hana Company has three separate operating branches: Division X, which manufactures utensils; Division Y, which makes plates; and Division Z, which makes cooking pots. Each division operates its own facility. The company’s administrative

> Intel Corporation is mostly known by the public for manufacturing silicon chips for personal computers, but it does other things as well. Answer the following questions using the company’s Form 10-K for the period ended December 28, 2019. The Form 10-K c

> Pam’s Grocery Store has three departments—meat, canned food, and produce—each of which has its own manager. All departments are housed in a single store. Recently, the produce department has been suff

> During Year 2, Adaire Toy Company made 10,000 units of Model K, the costs of which follow. Unit-level materials costs (10,000 units × $30) $ 300,000 Unit-level labor costs (10,000 units × $40) 400,000 Unit-level overhead costs (10,000 × $8) 80,000 Depre

> One of Riku Company’s major products is a fuel additive designed to improve fuel efficiency and keep engines clean. Riku, a petrochemical firm, makes and sells 100,000 units of the fuel additive per year. Its management is evaluating the possibility of h

> Schmidt Company made 100,000 electric drills in batches of 1,000 units each during the prior accounting period. Normally, Schmidt markets its products through a variety of hardware stores. The following is the summarized cost to produce electric drills.

> Quinn Machines Company is evaluating two customer orders. It can accept only one because of capacity limitations. The data associated with each order follow. Required 1. Assume that Quinn has decided to accept one of the two orders. Identify the informat

> Respond to each requirement independently. 1. Describe two decision-making contexts, one in which unit-level labor costs are avoidable and the other in which they are unavoidable. 2. Describe two decision-making contexts, one in which batch-level shippin

> Steve Gauthier, the president of Southern Plastic Company, is a famous cost cutter in the plastics industry. Two years ago, he accepted an offer from Southern’s board of directors to help the company cut costs quickly. In fact, Mr. Gaut

> Moreno Corporation manufactures two different coffee makers, Professional for commercial use and Home for family use. Albert Moreno, the president, recently received complaints from some members of the board of directors about the companyâ€&#1

> Klein Corporation manufactures two models of watches. Model Wonder displays cartoon characters and has simple features designed for kids. Model Marvel has sophisticated features such as dual time zones and an attached calculator. Klein’

> Miller Furniture Corporation makes two types of dining tables, Elegance for formal dining and Comfort for casual dining, at its single factory. With the economy beginning to experience a recession, Hank Miller, the president, is concerned about whether t

> The following information is from the accounts of Depree Manufacturing Company for Year 2. Required Divide the class into groups of four or five students per group and organize the groups into three sections. Assign Task 1 to the first section of groups,

> Elmore CPA and Associates is a local accounting firm specializing in bookkeeping and tax services. The firm has four certified public accountants who supervise 20 clerks. The clerks handle basic bookkeeping jobs and prepare tax return drafts. The CPAs re

> Garza Corporation has three production departments: forming, assembly, and packaging. The maintenance department supports only the production departments; the computer services department supports all departments, including maintenance. Other relevant in

> Templeton Furniture Company has two production departments. The parts department uses automated machinery to make parts; as a result, it uses very few employees. The assembly department is labor intensive because workers manually assemble parts into fini

> Mountain Tea Co. makes two products: a high-grade tea branded Wulong and a low-grade tea branded San Tea for the Asian market. Mountain purchases tea leaves from tea firms in mountainous villages of Taiwan and processes the tea leaves into a high-quality

> Dickson Furniture Company incurred the following costs in the process of making tables and chairs. Glue: Paint Supervisor salaries: Water bill Gas bill: Vacation pay Payroll taxes: Sewer bill Cost of nails: Staples Medical insurance: Electric bill Requir

> Fletcher Corporation has hired a marketing representative to sell the company’s two products: Marvelous and Wonderful. The representative’s total salary and fringe benefits are $8,000 monthly. The product cost is $150 per unit for Marvelous and $240 per

> Pruitt Corporation’s overhead costs are usually $20,000 per month. However, the company pays $120,000 of real estate tax on the factory facility in March. Thus, the overhead costs for March increase to $140,000. The company normally uses 5,000 direct lab

> Copeland Door Corporation makes a particular type of door. The labor cost is $120 per door and the material cost is $160 per door. Copeland rents a factory building for $80,000 a month. Copeland plans to produce 24,000 doors annually. In March and April,

> Lincoln, Snyder, and Associates provides legal services for its local community. In addition to its regular attorneys, the firm hires some part-time attorneys to handle small cases. Two office managers assist all part-time attorneys exclusively. In Year

> Fokine Research Institute has three departments: biology, chemistry, and physics. The institute’s controller wants to estimate the cost of operating each department. He has identified several indirect costs that must be allocated to eac

> Phalanges Systems, Inc. (PSI) makes keypads that it sells to manufacturers of products such as ATMs and PIN machines. The average materials cost per keypad is $4.70, and the average labor cost is $1.45. PSI incurs approximately $5,900,000 of fixed manufa

> Lamb Tools Company has two production departments in its manufacturing facilities. Home tools specializes in hand tools for individual home users, and professional tools makes sophisticated tools for professional maintenance workers. Lambâ€&#1

> Executive officers of Roth Company have prepared the annual budgets for its two products, Washer and Dryer, as follows. Table Summary: A table has 4 columns. Column 1 has entries. Column 2 has washer. Column 3 has dryer. Column 4 has total. Washer is div

> Milton Company sells tennis racquets; variable costs for each are $45, and each is sold for $135. Milton incurs $540,000 of fixed operating expenses annually. Required 1. Determine the sales volume in units and dollars required to attain a $270,000 profi

> O’Hara Company makes a product that it sells for $200. O’Hara incurs annual fixed costs of $250,000 and variable costs of $160 per unit. Required The following requirements are interdependent. For example, the $50,000 desired profit introduced in Require

> Egan Company is analyzing whether its new product will be profitable. The following data are provided for analysis. Expected variable cost of manufacturing $24 per unit Expected fixed manufacturing costs $65,000 per year Expected sales commission $6 per

> Jerome Company has three distinctly different options available as it considers adding a new product to its automotive division: engine oil, coolant, or windshield washer. Relevant information and budgeted annual income statements for each product follow

> Executive officers of Norman Company are assessing the profitability of a potential new product. They expect that the variable cost of making the product will be $60 per unit and fixed manufacturing cost will be $720,000. The executive officers plan to s

> Stackhouse Company manufactures and sells its own brand of digital cameras. It sells each camera for $250. The company’s accountant prepared the following data. Manufacturing costs Variable $90 per unit Fixed $300,000 per year Selling and administrative

> Kilner Company reported the following data regarding the one product it sells. Sales price $40 Contribution margin ratio 30% Fixed costs $540,000 per year Required Use the contribution margin ratio approach and consider each requirement separately. 1. Wh

> Vezinov Company manufactures portable heaters and sells them for $200 each. According to the company’s records, the variable costs, including direct labor and direct materials, are $80. Factory depreciation and other fixed manufacturing costs are $960,00

> ASAP Delivery is a small company that transports business packages between San Francisco and Los Angeles. It operates a fleet of small vans that moves packages to and from a central depot within each city and uses a common carrier to deliver the packages

> Mantooth Manufacturing Company experienced the following accounting events during its first year of operation. With the exception of the adjusting entries for depreciation, assume that all transactions are cash transactions. 1. Acquired $50,000 by issuin

> Stan Fox, the production manager of Hollis Construction Components, is trying to figure out the cost behavior of his factory supplies cost. The company uses machine hours as the cost driver. Joe Parrish, the assistant manager, collected the following cos

> Jenkins Frames Company, which manufactures ornate frames for original art work, began operations in January, Year 1. Bruce Preston, the owner, asks for your assistance. He believes that he needs to better understand the cost of the frames for pricing pur

> Kane Legal Services provides legal advice to clients. The following data apply to the first six months of operation. Required 1. What is the average service revenue per hour for the six-month time period? 2. Use the high-low method to estimate the total

> West Tours, Inc., organizes adventure tours for people interested in visiting a desert environment. A desert tour generally lasts three days. West provides food, equipment, and guides. Dan Silva, the president of West Tours, needs to set prices for the c

2.99

See Answer