Question

In: Accounting

Please include the formulas for everything. 1. The Xin Accounting Company (hereinafter abbreviated as “Xin”) produces...

Please include the formulas for everything. 1. The Xin Accounting Company (hereinafter abbreviated as “Xin”) produces managerial accounting study aids. The company is preparing budgets for the second quarter ending June 30. All amounts in the budgets are rounded to the nearest cent. The sales forecast for April through August is: April 15,000 units May 38,000 units June 21,000 units July 19,000 units August 11,000 units The selling price is $13 per unit. Prepare a Sales Budget for Xin. Hint: You may need to consider July and August information in order to complete some of the budgets for Q2. Therefore, you may need to have columns for July and August in some of the budgets when necessary. Remember, your job is to create Q2 (April-June) budgets. July and August columns are used to only help you create Q2 budgets. You don’t need to have July and August columns in all budgets.

2. The company desires to have finished inventory on hand at the end of each month equal to 20 percent of the following month's budgeted unit sales. On March 31, there were 3,600 units on hand. Prepare a Production budget.

3. Five pounds of material are required per unit of product. Management desires to have materials on hand at the end of each month equal to 12 percent of the following month's production needs. This policy was met on March 31st. The material costs $0.40 per lb. Prepare a Direct Materials Purchases budget.

4. Each unit produced requires 0.06 hours of direct labor. Each hour of direct labor costs the company $15. Prepare a Direct Labor budget.

5. Variable manufacturing overhead is $20 per direct labor hour. Fixed manufacturing overhead in total is $50,500 per month. This includes $20,500 of depreciation. Prepare a Manufacturing Overhead budget. You can just provide total fixed manufacturing overhead without separately listing depreciation on the Manufacturing Overhead budget.

6. Prepare an ending finished goods inventory budget for the end of the second quarter.

7. Prepare a cost of goods sold budget. The production cost per unit at the end of March is $14.

8. Variable selling and administrative expenses are $0.50 per unit sold. Fixed selling and administrative expenses in total are $70,000 per month which includes $10,000 in depreciation. Prepare a Selling & Administrative Expense budget. You can just provide total fixed selling and administrative expenses without separately listing depreciation on the Selling & Administrative Expense budget.

9. Prepare a budgeted income statement. Assume that the tax rate is 30%.

10. Prepare a cash collection schedule of sales for the second quarter. Xin’s cash sales are insignificant (In other words, assume no cash sales.). They collect 30% of their sales in the month of sale, 60% in the month after, 8% two months after, and then the remainder is written off (won’t be collected). Actual sales for February and March this year were $270,000 and $290,000 respectively. The collection percentages also apply to February and March.

11. Xin purchases 80% of its raw materials on account and 20% by cash. 70% of the credit purchases are paid for in the month of purchase; the remaining 30% are paid for in the following month. The purchase for March this year was $65,000. The collection percentages also apply to March. Prepare a cash disbursement schedule for raw materials. You may need to have a separate row for cash purchase.

12. Here are some other details: a. A $20,000 minimum cash balance is required for the end of each month. Money can be borrowed and repaid in multiples of $1,000. Interest is 12% per year. Interest payments are made only for the amount of the principal being repaid. All borrowing takes place at the beginning of a month, and all repayment (principal and interest) takes place at the end of a month. b. Please be aware of the depreciation in the overhead budget and Selling & Administrative Expense budget. c. The capital budget for the coming year revealed plans to purchase additional equipment. The cash outlay for the equipment, $60,000, will take place in April. The company plans to finance the acquisition of the equipment with operating cash, supplementing it with short-term loans as necessary. d. Corporate income taxes are approximately $100,000 and will be paid at the end of June. e. Beginning cash balance is $5,000 in April.

Solutions

Expert Solution

1. Production budget -

2. Direct Materials Purchases budget -

3. Direct Labor budget -

4. Manufacturing Overhead budget -

5. Selling & Administrative Expense budget -

6. Cash Budget -

Working Note -


Related Solutions

1. The Xin Accounting Company (hereinafter abbreviated as “Xin”) produces managerial accounting study aids. The company...
1. The Xin Accounting Company (hereinafter abbreviated as “Xin”) produces managerial accounting study aids. The company is preparing budgets for the second quarter ending June 30. All amounts in the budgets are rounded to the nearest cent. The sales forecast for April through August is: April 15,000 units May 38,000 units June 21,000 units July 19,000 units August 11,000 units The selling price is $13 per unit. Prepare a Sales Budget for Xin. Hint: You may need to consider July...
*Please include Spreadsheets and formulas, if applicable* The distribution system for the Herman Company consists of...
*Please include Spreadsheets and formulas, if applicable* The distribution system for the Herman Company consists of three plants, two warehouses, and four customers. Plant capacities and shipping costs per unit (in $) from each plant to each warehouse are as follows Warehouse Plant 1 2 Plant Capacity A 5 7 470 B 8 5 610 C 5 6 400 Customer demand and shipping costs per unit (in $) from each warehouse to each customer are as follows: Customer Warehouse Nikki...
Please start from Manufacutring Overhead Budget and please include formulas on how you got that answer...
Please start from Manufacutring Overhead Budget and please include formulas on how you got that answer This assignment asks you to set up an Excel budget spreadsheet file that automatically prepares the master budget for a company, given sales projections and information on beginning balances, production requirements, desired ending inventories, etc. Information on developing the budgets appears in Chapter 8 of your text, and examples of budget worksheets appear in the schedules throughout the chapter. Data Glamour Inc. produces and...
Please solve the problem below and include the excel formulas to the answers: Date MSFT SFY...
Please solve the problem below and include the excel formulas to the answers: Date MSFT SFY GM Portfolio Russell 3000 7/2/2012 -0.0364 -0.1328 -0.0005 -0.0566 0.0087 8/1/2012 0.0529 0.0062 0.0832 0.0474 0.0225 9/4/2012 -0.0275 0.0392 0.0655 0.0257 0.0246 10/1/2012 -0.0412 0.0249 0.1212 0.0350 -0.0185 11/1/2012 -0.0595 0.0489 0.0147 0.0014 0.0051 12/3/2012 0.0128 0.0682 0.1142 0.0651 0.0102 1/2/2013 0.0275 0.0741 -0.0257 0.0253 0.0537 2/1/2013 0.0210 0.2394 -0.0334 0.0757 0.0110 3/1/2013 0.0380 0.1122 0.0246 0.0583 0.0376 4/1/2013 0.1571 -0.1383 0.1084 0.0424 0.0153...
PLEASE INCLUDE EXCEL FORMULAS OR WORK Prepare (7) operating budgets for the year by quarter &...
PLEASE INCLUDE EXCEL FORMULAS OR WORK Prepare (7) operating budgets for the year by quarter & budgeted Income Statement for the Candy business Sales Information: Company advertises that it will match the competition (Internal factor) Five year historical selling total units per year: 220k, 210k, 180k, 196k, & 200k Surrounding shopping area includes discount stores (i.e. Target, Walmart) selling similar product for $15, $20 respectively (external factor) Stock Market down 25% in last 3 months, oil per barrel at record...
I'm using this to study for an exam, please write out all steps and include formulas,...
I'm using this to study for an exam, please write out all steps and include formulas, thank you! The world's fastest land animal, the cheetah, can accelerate at 8.75 m/s2 to a top speed of vcmax = 30.5 m/s. A cheetah observes a passing gazelle traveling at vg = 19.1 m/s and begins to chase it. (a) How long, in seconds, does it take the cheetah to reach its maximum velocity, vcmax, assuming its acceleration is constant? (b) How far,...
Please include formulas and work Suppose that you sell short 500 shares of Intel, which is...
Please include formulas and work Suppose that you sell short 500 shares of Intel, which is currently selling for $20 per share. Your broker requires 40% initial margin in short sales, which you covered using the T- bills in your account. Assume that the maintenance margin is 20%. How high can Intel's price rise before you get a margin call? How much money would you have to put into your account in order to satisfy the maintenance margin requirement if...
*please use excel and provide the formulas Acme Systems, Inc. produces a very large volume of...
*please use excel and provide the formulas Acme Systems, Inc. produces a very large volume of plastic rods on a regular basis. These rods require an extremely accurate diameter. Thus, the Quality Control manager wants to know if the production process is producing rods at a consistent diameter. 220 rods have been sampled each day for 10 days. Defects have been recorded. Develop a “p” control chart for the proportion of defects across the 10 days. Assume Z = 2.58....
Please Include excel formulas Income Statement for the Year Ending December 31 (Millions of Dollars) 2015...
Please Include excel formulas Income Statement for the Year Ending December 31 (Millions of Dollars) 2015 Net Sales $800.0 Costs (except depreciation) $576.0 Depreciation $60.0 Total operating costs $636.0 Earning before int. & tax $164.0 Less interest $32.0 Earning before taxes $132.0 Taxes (40%) $52.8 Net income before pref. div. $79.2 Preferred div. $1.4 Net income avail. for com. div. $77.9 Common dividends $31.1 Addition to retained earnings $46.7 Number of shares (in millions) 10 Dividends per share $3.11 Balance...
Please answer each question set on a separate Excel worksheet, labeled appropriately and include excel Formulas...
Please answer each question set on a separate Excel worksheet, labeled appropriately and include excel Formulas Question Set 1. You are in charge of quality control for computer monitors at Dell. You have data on twenty-five batches of monitors, tracking five types of defects: brightness, color, contrast, dead pixels, and stuck pixels. These data are given in the table below. 1. For each defect type, find the average number of defects per batch. So, you should have an average defect...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT