Question

In: Accounting

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 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

Formulas:


Related Solutions

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:...
1. In comparing financial accounting with managerial accounting, managerial accounting A.    Follows GAAP or IFRS reporting...
1. In comparing financial accounting with managerial accounting, managerial accounting A.    Follows GAAP or IFRS reporting standards. B.    Emphasizes timeliness and sub-unit reporting such as business units, divisions, departments. C.    Reports to parties external to the company D.    Emphasizes financial consequences of past activities 2. When production decreases A.    Variable costs per unit decrease. B.    Variable costs per unit increase. C.    Total variable costs increase. D.    Total variable costs decrease. 3. Which of the following is an indirect production cost...
describe managerial accounting and the role of managerial accounting in business.
describe managerial accounting and the role of managerial accounting in business.
Managerial Accounting
Managerial Accounting
1       What do you understand by “Managerial Accounting”? Explain tools and techniques of Managerial Accounting. Hint:...
1       What do you understand by “Managerial Accounting”? Explain tools and techniques of Managerial Accounting. Hint: -          Introduction -          Meaning of Managerial Accounting -          Definitions of Managerial Accounting -          Tools and Techniques of Managerial Accounting -          Conclusion
Chapter 1 Managerial Accounting and Cost Concepts
1–12 What is the contribution margin?1–13 Define the following terms: differential cost, sunk cost, and opportunity cost.1–14 Only variable costs can be differential costs. Do you agree? Explain.
Chapter 1 Managerial Accounting and Cost Concepts
Northwest Hospital is a full-service hospital that provides everything from major surgery and emergency room care to outpatient clinics.Required:For each cost incurred at Northwest Hospital, indicate whether it would most likely be a direct cost or an indirect cost of the specified cost object by placing an X in the appropriate column.
Chapter 1 Managerial Accounting and Cost Concepts
1–5 What effect does an increase in the activity level have on—a. Average fixed costs per unit?b. Variable costs per unit?c. Total fixed costs?d. Total variable costs?1–6 Define the following terms: (a) cost behavior and (b) relevant range.1–7 What is meant by an activity base when dealing with variable costs? Give severalexamples of activity bases.1–8 Managers often assume a strictly linear relationship between cost and the level of activity.Under what conditions would this be a valid or invalid assumption?
1. Identify the role and scope of financial and managerial accounting and the use of accounting...
1. Identify the role and scope of financial and managerial accounting and the use of accounting information in the decision making process of managers. 2. Define operational and capital budgeting, and explain its role in planning, control, and decision making.
managerial accounting question
A company produces and sells a product with the following information: Selling price per unit: $100 Variable cost per unit: $50 Fixed costs per month: $30,000 Expected sales volume per month: 1,000 units The company is considering a proposal to increase the selling price to $110 per unit, which is expected to reduce sales volume to 900 units per month. Alternatively, the company could reduce variable costs per unit to $45 by improving efficiency, which is expected to increase sales...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT