Question Orange Company purchased a drilling machine in 2010 for P240,000. The machine was depreciated on the straight-line method over an estimated useful life of 20 years, with no salvage value. At the beginning of 2020, when the machine had been in use for 10 years, the company paid P40,000 to overhaul the machine. As a result of this improvement, the company estimated that the useful life of the machine would be extended an additional 5 years. What would be the depreciation expense recorded for the machine in 2020? *

Victory Company uses weighted average process costing. The company has two production processes. Conversion cost is added evenly throughout each process. Direct materials are added at the beginning of the first process Additional information for the first process follows Direct Materials Conversion Percent Percent Units Complete Complete Beginning work in process inventory 72, eee 100% 80% Units started this period 833,eee Units completed and transferred out 71e,eee Ending work in process inventory 195, eee 1ees 50% Beginning work in process inventory Direct materials $ 411,775 Conversion 100,938 $ 512, 713 Costs added this period Direct materials 2,755,725 Conversion 1,917,812 4,673,537 Total costs to account for $ 5,186,250 Required: 1. Compute equivalent units of production for both direct materials and conversion Equivalent Units of Production (EUP). Weighted Average Method Units % Materials EUP-Materials % Conversion EUP. Conversion Total units 2. Compute cost per equivalent unit of production for both direct materials and conversion Cost per equivalent unit of production Materials Conversion Costs Costs Total costs Equivalent units of production (from part 1) Cost per equivalent unit of production EUP EUP 0 0 3. Assign costs to the department's output-specifically, to the units transferred out and to the units in ending work in process Inventory (Round "Cost per EUP" to 2 decimal places.) EUP Cost per EUP Total cost Cost assignment-Weighted average Completed and transferred out Direct materials Conversion Total completed and transferred out Ending work in process Direct materials Conversion Total ending work in process Total costs accounted for $ 0 0.00 $ 0.00 S 0

Help please A thin walled cylindrical pressure vessel is subjected to an internal pressure which varies from 750 KPa to 3550 KPa continuously. The diameter of the shell is 1.5 m. Find the required thickness of the cylinder wall based on yield point of 480 MPa, net endurance limit of 205 MPa and a factor of safety of 2.5. A camshaft 19 mm. in diameter is mounted on ball bearings and carries a cam midway from the bearings. The follower, which weighs 2.8 KN, is out of adjustment so that impact is produced when it is contacted by the cam. The height h of fall equals 0.254 mm. The shaft is made of AISI C1045 steel. Determine the maximum bending stress in the shaft.

Consider the following diagram: Internet Modem Wireless AP Switch Wireless AP DO Wireless AP Server 2.1 Using a table, compare 4 types of area networks. Consider the size of the network and the transmission media that is most likely to be found in each type of network. (8) 2.2 Based on the information given in 2.1, which type if network is shown in the Consider the following diagram: Internet Modem Wireless AP Switch Wireless AP DO Wireless AP Server 2.1 Using a table, compare 4 types of area networks. Consider the size of the network and the transmission media that is most likely to be found in each type of network. (8) 2.2 Based on the information given in 2.1, which type if network is shown in the diagram? Motivate your (2) answer. 2.3 This network has wireless access points. Compare three modulation techniques, using sketches, that could be used by these access points to transmit data. Use the bit-stream 10000101111. (6)

P3.5 The sales revenue, food cost of sales, and guests served for a small fast- food carryout division of a restaurant for the past six months are given below. Sales Month Cost of Revenue Guests Served Sales, Food 1 2. 4 $258,200 274,800 285,600 289,400 298,300 304,600 $ 96,200 104,300 110,500 113,100 118,900 123,700 10,200 10,400 10,300 10,100 10,400 10,500 6 For each of the six months calculate average check and average costs of sales food. Using these averages, calculate an index number. Set the in- dex for month 1 at 100 and complete index numbers for the remaining five months. With the index numbers identified, convert sales revenue and cost of sales food from historic to current dollars.

2.7 LAB - Alter Movie table The Movie table has the following columns: ID - integer, primary key Title - variable-length string Genre - variable-length string RatingCode - variable-length string Year - integer Write ALTER statements to make the following modifications to the Movie table: Add a Producer column with VARCHAR data type (max 50 chars). Remove the Genre column. Change the Year column's name to ReleaseYear, and change the data type to SMALLINT.

Help in SQL.. please take your time 3.12 LAB - Create LessonSchedule table with FK constraints Two tables are created: 1. Horse with columns: - ID - integer, primary key RegisteredName - variable-length string 2. Student with columns: ID - integer, primary key FirstName - variable-length string LastName - variable-length string Create the Lesson Schedule table with columns: • HorselD-integer with range 0 to 65 thousand, not NULL, partial primary key, foreign key references HorseID) • StudentID - integer with range 0 to 65 thousand, foreign key references Student(ID) • LessonDate Time - date/time, not NULL, partial primary key If a row is deleted from Horse, the rows with the same horse ID should be deleted from LessonSchedule automatically. If a row is deleted from Student, the same student IDs should be set to NULL in Lesson Schedule automatically. 387240.1399152.qx3zay? LAB ACTIVITY 3.12.1: LAB - Create Lesson Schedule table with FK constraints 0/10 Main.sql Load default template... 1 CREATE TABLE Horse ( 2 ID SMALLINT UNSIGNED AUTO_INCREMENT, 3 RegisteredName VARCHAR(15), 4. PRIMARY KEY (ID) 5); 7 CREATE TABLE Student ( 8 ID SMALLINT UNSIGNED AUTO_INCREMENT, 9 FirstName VARCHAR(20), 10 LastName VARCHAR(30), 11 PRIMARY KEY (ID) 12 ); 13 If a row is deleted from Student, the same student IDs should be set to NULL in LessonSchedule automatically. SB/270.7399152 gy LAB ACTIVITY 3.12.1: LAB - Create Lesson Schedule table with FK constraints 0/10 Main.sql Load default template... 1 CREATE TABLE Horse 2 2 ID SMALLINT UNSIGNED AUTO_INCREMENT, 3 RegisteredName VARCHAR(15), 4 PRIMARY KEY (ID) 5); 6 7 CREATE TABLE Student 8 ID SMALLINT UNSIGNED AUTO_INCREMENT, 9 FirstName VARCHAR(20), 10 Last Name VARCHAR(30), 11 PRIMARY KEY (ID 12); 13 14 -- Your SQL statements go here 15 16 17 Develop mode Submit mode Explore the database and run your program as often as you'd like, before submitting for grading. Click Run program and observe the program's output in the second box. Main.sql Run program Output (shown below) (Your program) Program output displayed here Coding trail of your work What is this? History of your effort will appear here once you begin working on this zylab.