Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q. Using information from Analysis worksheet of Prestige Telephone Company, completete Expenses worksheet. Exhibit1 Prestige Data Services Summary of Computer Ullization, First Quarter 2003 Revenue
Q. Using information from Analysis worksheet of Prestige Telephone Company, completete Expenses worksheet.
Exhibit1 Prestige Data Services Summary of Computer Ullization, First Quarter 2003 Revenue Hours January February March 223 208 123 181 135 138 329 Intercompany Commercial Total revenue hours Service hours Available hours Total hours 381 40 32 223 316 32 184 512 143 644 684 Exhibit 2 Prestige Data Services Summary Results of Operations, First Quarter 2003 January February March $82,400 $72,400 $89,200 Revenues Intercompany sales Commercial sales Computer use Other Total revenue Expenses Space costs: Rent Custodial services 98,400 9.241 $190.041 108,000 9,184 $189,584 110,400 12.685 S212,285 $8,000 1,240 9,240 $8,000 1.240 9,240 $8.000 1,240 9.240 95.000 5,400 95,000 5.400 95,000 5,400 Equipment costs Computer leases Maintenance Depreciation: Computer equipment Office equipment and fixtures Power 25,500 880 25.500 680 1.592 128.172 1.633 128.213 25,500 880 1.803 128.383 Wages and salaries Operations Systems development and maintenance Administralian Sales Materials Sales promotions Corporate services Total expenses Net income (loss) 29,496 12.000 9,000 11.200 61,696 9,031 7.909 15.424 $231.513 S(41.472) 29.184 12,000 9.000 11.200 61,384 8.731 7,039 15,359 S229.925 5140.341 30,264 12.000 9,000 11.200 62 464/ 10.317 8,083 15,236 $233723 $121.438) 1. Using the information from the Analysis worksheet, complete the shaded cells. Prestige Data Services Standard Costs -- Average Month Variable Expenses: per hour per hour Total Variable Expenses per hour per hour Nonvariable Expenses: Wages and Salaries: Total Wages and Salaries Sales Promotion (assume: programmed cost) 8.000 Total Nonvariable Expenses Other commercial sales revenue anim Exhibit1 Prestige Data Services Summary of Computer Ullization, First Quarter 2003 Revenue Hours January February March 223 208 123 181 135 138 329 Intercompany Commercial Total revenue hours Service hours Available hours Total hours 381 40 32 223 316 32 184 512 143 644 684 Exhibit 2 Prestige Data Services Summary Results of Operations, First Quarter 2003 January February March $82,400 $72,400 $89,200 Revenues Intercompany sales Commercial sales Computer use Other Total revenue Expenses Space costs: Rent Custodial services 98,400 9.241 $190.041 108,000 9,184 $189,584 110,400 12.685 S212,285 $8,000 1,240 9,240 $8,000 1.240 9,240 $8.000 1,240 9.240 95.000 5,400 95,000 5.400 95,000 5,400 Equipment costs Computer leases Maintenance Depreciation: Computer equipment Office equipment and fixtures Power 25,500 880 25.500 680 1.592 128.172 1.633 128.213 25,500 880 1.803 128.383 Wages and salaries Operations Systems development and maintenance Administralian Sales Materials Sales promotions Corporate services Total expenses Net income (loss) 29,496 12.000 9,000 11.200 61,696 9,031 7.909 15.424 $231.513 S(41.472) 29.184 12,000 9.000 11.200 61,384 8.731 7,039 15,359 S229.925 5140.341 30,264 12.000 9,000 11.200 62 464/ 10.317 8,083 15,236 $233723 $121.438) 1. Using the information from the Analysis worksheet, complete the shaded cells. Prestige Data Services Standard Costs -- Average Month Variable Expenses: per hour per hour Total Variable Expenses per hour per hour Nonvariable Expenses: Wages and Salaries: Total Wages and Salaries Sales Promotion (assume: programmed cost) 8.000 Total Nonvariable Expenses Other commercial sales revenue anim
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started