ADMS 1500 Study Guide - Midterm Guide: Market Power, Quick Ratio, Asset Turnover
Get access
Related Documents
Related Questions
13-58 Comprehensive Budget Plan
Panther Corporation appeared to be experiencing a good year. Sales in the first quarter were one-third ahead of last year, and the sales department predicted that this rate would continue throughout the entire year. The controller asked Janet Nomura, a summer accounting intern, to prepare a draft forecast for the year and to analyze the differences from last year's results. She based the forecast on actual results obtained in the first quarter plus the expected costs of production to be completed in the remainder of the year. She worked with various department heads (production, sales, and so on) to get the necessary information. The results of these efforts follow:
Panther Corporation | ||
Expected Account Balances for December 31, Year 2 | ||
Cash | $4,800 | |
Accounts receivable | $320,000 | |
Inventory (January 1, year 2) | $192,000 | |
Plant and equipment | $520,000 | |
Accumulated depreciation | $164,000 | |
Accounts payable | $180,000 | |
Notes payable (due within one year) | $200,000 | |
Accrued payables | $93,000 | |
Common stock | $280,000 | |
Retained earnings | $432,800 | |
Sales revenue | $2,400,000 | |
Other income | $36,000 | |
Manufacturing costs: | ||
Materials | $852,000 | |
Direct labor | $872,000 | |
Variable overhead | $520,000 | |
Depreciation | $20,000 | |
Other fixed overhead | $31,000 | |
Marketing: | ||
Commissions | $80,000 | |
Salaries | $64,000 | |
Promotion and advertising | $180,000 | |
Administrative: | ||
Salaries | $64,000 | |
Travel | $10,000 | |
Office costs | $36,000 | |
Income taxes | ------ | |
Dividends | $20,000 | |
$3,785,800 | $3,785,800 |
Adjustments for the change in inventory and for income taxes have not been made. The scheduled production for this year is 450,000 units, and planned sales volume is 400,000 units. Sales and production volume was 300,000 units last year. The company uses a full-absorption costing and FIFO inventory system and is subject to a 40% income tax rate. The actual income statement for last year follows:
Panther Corporation | |||
Statement of Income and Retained Earnings | |||
For the Budget Year Ended December 31, Year 1 | |||
Revenues: | |||
Sales revenue | $1,800,000 | ||
Other income | $60,000 | $1,860,000 | |
Expenses: | |||
Cost of goods sold | |||
Materials | $528,000 | ||
Direct labor | $540,000 | ||
Variable overhead | $324,000 | ||
Fixed overhead | $48,000 | ||
$1,440,000 | |||
Beginning inventory | $192,000 | ||
$1,632,000 | |||
Ending inventory | $192,000 | $1,440,000 | |
Selling: | |||
Salaries | $54,000 | ||
Commissions | $60,000 | ||
Promotion and advertising | $126,000 | $240,000 | |
General administrative: | |||
Salaries | $56,000 | ||
Travel | $8,000 | ||
Office costs | $32,000 | $96,000 | |
Income taxes | $33,600 | $1,809,600 | |
Operating profit | $50,400 | ||
Beginning retained earnings | $402,400 | ||
Subtotal | $452,800 | ||
Less dividends | $20,000 | ||
Ending retained earnings | $432,800 |
Required
Prepare a balance sheet.
Case 3
Part 1 Master Budgets
Pizza L.L.C. operates pizza delivery and carry-out restaurants.The annual report describes its business as follows: We offer afocused menu of high-quality, value-priced pizza with three typesof crust (Hand-Tossed, Thin Crust, and Deep Dish), made from freshdough produced in our regional distribution centers. We prepareevery pizza using real cheese, pizza sauce made from freshtomatoes, and a choice of high-quality meat and vegetable toconsistently and efficiently produce the highest-quality pizza.
Over the 41 years since our founding, we have developed asimple, cost-efficient model. We offer a limited menu, our storesare designed for delivery and carry-out, and we do not generallyoffer dine-in service. As a result, our stores require relativelysmall, lower-rent locations and limited capital expenditures.
How would a master budget support planning, directing, andcontrol for Pizza LLC? Include the three major objectives ofbudgeting? Under what circumstances would a static budget beappropriate?
Briefly describe the type of human behavior problems that mightarise if budget goals are set too tightly? Too loosely? Or ifconflicting goals within the budget?
Why should the production requirements set forth in theproduction budget be carefully coordinated with the sales budgetAND Why should the timing of direct materials purchases be closelycoordinated with the production budget?
Budget performance report
The Box Company (BC) manufactures boxes for the pizza industry.The cost standards per 100 boxes are:
Cost Category Standard cost per 100 boxes
Direct labor 2.00
Direct materials 9.10
Factory overhead .55
Total 11.65
At the beginning of July, BC management planned sales andproduction of 400,000 boxes. The actual number of boxes sold andproduced for July was 406,000 boxes.
The actual production costs for July of the current year were asfollows:
Cost Category Standard cost per 100 boxes
Direct labor 7540
Direct materials 35750
Factory overhead 2680
Total 45970
Prepare the July manufacturing standard cost budget (directlabor, direct materials, and overhead) for BC, assuming plannedproduction.
Prepare a budget performance report for manufacturing costs,showing the total cost variances for direct materials, directlabor, and factory overhead for July.
Interpret the budget performance report.
Part 2 Evaluating Divisional Performance and Capital InvestmentAnalysis
The three divisions of a Foods Co. are Snacks, Morning Foods,and Frozen. The divisions are structured as investment centers. Thefollowing responsibility reports were prepared for the threedivisions for the prior year:
Snack Morning Foods Frozen
Revenues 2200000 2520000 2100000
Operating Expenses 1366600 1122000 976800
Income from Op
Before service dept 833400 1398000 1123300
Service dept charges
Promotion 300000 600000 468000
Legal 137400 243600 235200
Total Service Dept charges 437400 843600 703200
Income from Operations 396000 554400 420000
Invested Assets 2000000 1680000 1750000
Which division is making the best use of invested assets andshould be given priority for future capital investments? ConsiderROI, the acceptable and rate of return.
Assuming that the minimum acceptable rate of return on newprojects is 19%, would all investments that produce a return inexcess of 19% be accepted by the divisions?
Can you identify opportunities for improving the company'sfinancial performance?
Category | Points | Description |
Understanding | 10 | Demonstrate a strong grasp of the problem at hand. Demonstrateunderstanding of how the course concepts apply to the problem. |
Analysis | 20 | Apply original thought to solving the business problem. Applyconcepts from the course material correctly toward solving thebusiness problem. |
Execution | 20 | Write your answer clearly and succinctly using strongorganization and proper grammar. Use citations correctly. |
Total | 50 | A quality paper will meet or exceed all of the aboverequirements. |